Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2000
Query Tuning
Analyzing a Query
 Table Scan

  Switch on low bandwidth view
Optimizing Database Performance (SQL Server 2000)
Table Scan

Table Scan

The Table Scan logical and physical operator retrieves all rows from the table specified in the Argument column. If a WHERE:() predicate appears in the Argument column, only those rows that satisfy the predicate are returned.

See Also

SELECT

© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker