Importance of Index in Sql Server

  1. Indexing Provides a way to improve performance of Your data access queries.

Without index , it scan all records and logical and physical reads values are higher .

With index , logical and physical are reads less. so it enhance performance of Queries.

with index

Comparing Table Scan vs. Clustered Index

With Index It enhance I/O Cost, CPU Cost etc..

So, We should use index. if data volume are higher. It help us to find query result quickly. Happy Coding… Thanks.

Post Author: adama