Wednesday, September 18, 2013

Performance issue with selection of data on a table

Hi,


I am facing an issue with the performance. The selection of data from table is taking more than 20 sec to retrieve close to 300k records. Created a clustered index on col1 and col2 but no improvement.



Select Distinct Col1,Col2,Col3 + CHAR(13) + CHAR(10) Col3
From Table
Where Col3 IS NOT NULL
Order by Col1,Col2

Any suggestions would be really helpful!


Thanks,Eshwar.




Please don't forget to Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful. It will helpful to other users.


No comments:

Post a Comment