What is SQL Server internal index seek vs scan decision boundary?

The optimizer chooses seek or scan based on estimated selectivity and cost comparison.

Index seeks are efficient for highly selective predicates, while scans are preferred when a large portion of the table is accessed. The optimizer estimates row count using statistics and compares IO cost of random vs sequential access. If selectivity crosses a threshold, scan becomes cheaper due to reduced random IO overhead.