My dear fellow DBA's. I have a ?. I have the following query in SQL SERVER 2008 R2:
select top 50 * from myview and it runs in less than 3 sec.
I then change my query to select top 50 * from myview ORDER BY col4 and it runs forever. My user claim it has been working ok in the past, but last night we failed over to another instance in the cluster. I am trying to figure out why the query is taking too long when selecting and ORDERing from the view. I'am at a brick wall.
Any comments anybody