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

Answer:

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.