When viewing an execution plan, you may see that SQL Server decided to do a Seek or a Scan.
A Seek occurs when SQL Server knows where it needs to go and only grab specific items. This typically occurs when good filters on put in a query, such as where name = 'Foo'.
A Scan is when SQL Server doesn...
