CODEWITHSUNDEEP
sql-serverindexing
Cristian Abelleira
Cristian Abelleira

Reputation: 355

CLUSTERED Index seek taking too much cost

I have a really big sql select query that I have to optimize because it takes 40 seconds.

Im using Sql Sentry Plan Explorer to do so and I found that 2 "Clustered Index Seek operations" (in a 300k rows table) take nearly 60% of the whole process time.

My questions is: What could cause this "clustered index seek" to take so much time? When I do a simple select on this table it takes only 2 seconds but this index seek takes like 24 seconds...

I also checked index fragmentation and its over 2%.

NOTE: Sorry I dont post details but im not allowed to do so.

Upvotes: 0

Views: 1413

Answers (1)

Vyacheslav Shcherbak
Vyacheslav Shcherbak

Reputation: 94

At the first time you can try to update statistics.

For example so.

UPDATE STATISTICS ...

Or so.

EXEC sp_updatestats

Upvotes: 1

Related Questions