Press "Enter" to skip to content

Defining Index Seeks Down

Brent Ozar explains that index seeks aren’t always as selective as they sound:

When you see “index seek” on an execution plan, that doesn’t mean SQL Server is jumping to exactly the row you’re looking for. It only means that SQL Server is seeking on the first column of the index.

This is especially misleading on indexes where the first column isn’t very selective.

Definitely worth the read.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.