Index Seek vs Index Scan which is more efficient in SQL Server
Note: Index seek is better than index scan.
Index Seek is the best way to retrieve data from the database. It is one of the fastest ways to get data. When your search(where clause statement) matches an index then an index can navigate directly to a particular point to retrieve data in the database. It only guides toward the matching data rows.
Index Scan is the scan in which all the rows are scanned for the table. It is suitable for a smaller table but a larger table needs enough resources which cause performance issues or slowness. The cost is directly proportional to the number of rows in a table.