Col3 is taken out from where clause, i cannot include col3 in the index def because the data length in col3 is more than 8000 characters.
Select Distinct Col1,Col2,Col3 + CHAR(13) + CHAR(10) Col3
From Table
Order by Col1,Col2
Distinct has to be there as there are duplicates in the table. How to improve performance now.
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