Index seek vs Index Scan which is more effective in SQL Server

Index Seek vs Index Scan which is more efficient in SQL Server

Note: Index seek is better than index scan.

Index Seek is the best way to retrieve data from the database. It is one of the fastest ways to get data. When your search(where clause statement) matches an index then an index can navigate directly to a particular point to retrieve data in the database. It only guides toward the matching data rows.

Index Scan is the scan in which all the rows are scanned for the table. It is suitable for a smaller table but a larger table needs enough resources which cause performance issues or slowness. The cost is directly proportional to the number of rows in a table.



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

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