January 16, 2014 at 6:21 am
hi All,
Please provide the possible options to reduce the Index Seek Cost ?
January 16, 2014 at 6:43 am
First things first. Is that a problem? Is that query a problem?
If not, why are you worrying about it? The % cost has to be somewhere, it is a percentage.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 16, 2014 at 6:45 am
This depends on a whole lot of factors, you're just not giving enough information.
Anyway, an index seek means the index is being used for what is has been build, so that's usually a good thing.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 16, 2014 at 7:01 am
And remember, those costs are just estimated values. They don't represent a literal real-world performance metric. It's just a measure of what the optimizer thinks a given operation will cost based on the operation and the statistics presented to the optimizer.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply