Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Index Seek on Non Clustered Index cost is very high (92%) how to reduce this ? RE: Index Seek on Non Clustered Index cost is very high (92%) how to reduce this ?
MadAdmin
SSChampion
Points: 11261
More actions
July 24, 2014 at 4:37 pm
#1732217
Add an unnecessary sort.
That should make the index seek use proportionately less cost of the entire query.
But, why would you want to?
Catch-all queries done right [/url] Gail Shaw's Performance Blog[/url]