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