table scan and indexes

http://msdn.microsoft.com/en-us/library/aa224773(v=sql.80).aspx