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 |