I have a CRM app and I am having some bad performance on various queries. The queries that are bad performing bad happed to have an Order By statement When I run the Query without the Order By the performance gain is huge. And it doesn#%92t matter if you get one row returned or 10,000 rows the query is still slow. I am wondering what are some reasons why the Order By can case such bad performance?? I am thinking it has to do with an index, but what do you index? Do I need to create a non clustered index that covers the two order by columns? Why does the Where Clause not speed up the query? The Order By: T1.OWNER_EMP_ID DESC, T1.ACT_OPEN_DT DESC. The select query itself is massive (273 columns, 45 joins). The main table has over 2 million records. And no I can#%92t change this. Thanks.