Wednesday, September 18, 2013

Performance issue with selection of data on a table


Select ConsumerID,RecordType,
RecordData + CHAR(13) + CHAR(10) RecordData
From ETL.Stg_to_PP
Order by ConsumerID,RecordType

Taken out the distinct, added clustered index on col1,col2 Still this simple select with 300 thousand records is taking 8 sec. I cannot include Col3 as it is a nVarchar(max) column and the data in this more than 8000 characters.


Any suggestions on improving the performance.


Explain plan i know it doesnt show anything:






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