How does SQL Server decide between a Table Scan, Index Scan, and Index Seek?

Quick Answer SQL Server uses statistics (row count estimates) to pick the cheapest plan. Table Scan reads every row — used when there's no useful index or the whole table is needed. Index Scan reads the index but all rows. Index Seek jumps directly to matching rows — the most efficient, what you want for selective queries.