SQL Server Clustered Index Seek Operator

Hi Friends,

Let us look at Clustered Index Seek operator today. The statement below shows an example of SQL Server Index Seek (clustered) and of course database is our dearest AdventureWorks2012.

SELECT Address.AddressID,Address.AddressLine1,Address.City,Address.PostalCode
FROM Person.Address
WHERE Address.AddressID = 14918

CISeek CISeekToolTip

An index seek does not scan entire index, instead it navigates the B-tree structure to find one or more records quickly. An Index Seek be it clustered or non-clustered (we will cover in future post) takes place when SQL Server query optimizer able to locate an appropriate index to fetch required records that is, it sends an instruction to SQL engine to look up values based on the index keys.

A clustered index stores key structure as well as the data itself. In our example, we have a clustered index seek operation against Person.Address table and index used here is PK_Address_AddressID. ToolTip shows Ordered property is true indicating data is ordered by SQL Server query optimizer.

In tomorrow’s post we will have a comparison on how SQL Server Clustered index Seek is more effective than scans.

Happy learning!

Regards,

Kanchan

Like us on FaceBook | Join the fastest growing SQL Server group on FaceBookFollow me on TwitterFollow me on FaceBook

Avatar

About Kanchan Bhattacharyya

Kanchan is an astute IT professional, a seasoned SQL Database Administrator with 13+ years of industry experience. A calculated risk taker with deep technical knowledge and has gained proficiency in database consulting and solutions across different environments. Kanchan holds MBA degree in IT and an International Executive MBA in Project Management. He is very passionate about SQL Server and holds MCSE (Data Platform), MCSA – SQL 2012, MCITP – SQL 2008 certifications. Currently he is focusing on cloud and latest releases of SQL Server. When not working, Kanchan likes to spend his time reading on new technical developments specifically on SQL Server and other related technologies.

View all posts by Kanchan Bhattacharyya →

One Comment on “SQL Server Clustered Index Seek Operator”

  1. I have a question about SQL Server Clustered Index Seek Operator, if the order is false, this mean that the query optimizer was not able to locate an appropriate index

Leave a Reply

Your email address will not be published. Required fields are marked *