Clustered index scan and clustered index seek

Source: Internet
Author: User
Tags sql server query

In the Execution Plan of SQL Server Query analyzer, there are many scanning methods, including clustered index scan and clustered index seek. What are the differences between the two?

Clustered index, which is a clustered index, indicates that all of them use clustered index scanning.

Scan indicates that it scans a range or all content, and seek indicates scanning rows within a specific range. In other words, scan does not know what the target row is, and seek scan indicates that I already know what the target row is, so seek is generally faster.

Which of the following statements is scan and which is seek scan?

Use master
Go
Select * From sysobjects
Select * From sysobjects where name like 'sys %'
Select * From sysobjects where ID <3

Because the sysobjects table is a clustered index on the ID, scan is used for the first two query statements, and seek is used for the last two query statements.


Tered index scan and clustered index seek icons

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.