TABLE SCAN / INDEX SCAN , Index Seek Table Scan When SQL Server scans through all rows of a table one by one in order to find the appropriate rows. For large tables, table scan can take a long time…