8.24.2012

Difference between a table scan and an index scan in SQL Server Database

Difference between a table scan and an index scan in SQL Server Database
S.No
Table Scan
Index Scan
1 Here, row by row scanning is done to get the data. In case, there are huge number of data in a table, it becomes an overhead. Here in the first, index is created in the table. It then uses the index to get to the data that we wanted. It increases the performance.

No comments:

Post a Comment