Answer
SQL Server chooses access methods based on filters, available indexes, and cost estimates.
Table Scan: Reads all rows when no useful index exists.
Index Scan: Reads all index entries for broad filters.
Index Seek: Most efficient; jumps directly to matching rows.