Accessing Data Without Indexes: Table Scan
As explained before,table data is stored in pages, and pages are grouped in extents. Special pages called IAM (Index Allocation Map) keep information about which extents are used by a particular table.
Information related to table definition is stored in different system tables:
The name of the table, as well as the owner, creation date, and other general information, is stored in the sysobjects system table. The sysobjects table has a field called ID, which provides a unique object identification number for every object stored in a database. The ID field is used to relate this object to extra information in other systems'tables. It is possible to retrieve the table ID calling the OBJECT_ID system function. ...
Get Microsoft® SQL Server™ 2000 Programming by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
