- 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.
Comparing Table Scan vs. Clustered Index
So, We should use index. if data volume are higher. It help us to find query result quickly. Happy Coding… Thanks.