In SQL Server Database, what is the basic difference between a table scan and an index scan ?

 Posted by Akiii on 9/4/2011 | Category: Sql Server Interview questions | Views: 3765 | Points: 40

Table Scan --- 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.

Index Scan --- Here in the first, index is created in the table. It then uses the index to get to the data that you wanted. It increases the performance.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response