Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

sysindexes System Table - SQL Server 2000

RSS
Modified on Fri, May 01, 2009, 10:58 AM by Administrator Categorized as SQL Server System Tables
Contains one row for each index and table in the database. This table is stored in each database.

Column nameData typeDescription
idintID of table (for indid = 0 or 255). Otherwise, ID of table to which the index belongs.
statusintInternal system-status information.
firstbinary(6)Pointer to the first or root page.
indidsmallintID of index: 1 = clustered index; >1 = nonclustered; 255 = entry for tables that have TEXT or IMAGE data
rootbinary(6)For indid >= 1 and < 255, root is the pointer to the root page. For indid = 0 or indid = 255, root is the pointer to the last page.
minlensmallintMinimum size of a row.
keycntsmallintNumber of keys.
groupidsmallintFilegroup ID on which the object was created.
dpagesintFor indid = 0 or indid = 1, dpages is the count of data pages used. For indid=255, it is set to 0. Otherwise, it is the count of index pages used.
reservedintFor indid = 0 or indid = 1, reserved is the count of pages allocated for all indexes and table data. For indid = 255, reserved is a count of the pages allocated for text or image data. Otherwise, it is the count of pages allocated for the index.
usedintFor indid = 0 or indid = 1, used is the count of the total pages used for all index and table data. For indid = 255, used is a count of the pages used for text or image data. Otherwise, it is the count of pages used for the index.
rowcntbigintData-level rowcount based on indid = 0 and indid = 1. For indid = 255, rowcnt is set to 0.
rowmodctrintCounts the total number of inserted, deleted, or updated rows since the last time statistics were updated for the table.
xmaxlensmallintMaximum size of a row.
maxirowsmallintMaximum size of a nonleaf index row.
OrigFillFactortinyintOriginal fillfactor value used when the index was created. This value is not maintained; however, it can be helpful if you need to re-create an index and do not remember what fillfactor was used.
reserved1tinyintReserved.
reserved2intReserved.
FirstIAMbinary(6)Reserved.
impidsmallintReserved. Index implementation flag.
lockflagssmallintUsed to constrain the considered lock granularities for an index. For example, a lookup table that is essentially read-only could be set up to do only table level locking to minimize locking cost.
pgmodctrintReserved.
keysvarbinary(816)List of the column IDs of the columns that make up the index key.
namesysnameName of table (for indid = 0 or 255). Otherwise, name of index.
statblobimageStatistics BLOB.
maxlenintReserved.
rowsintData-level rowcount based on indid = 0 and indid = 1, and the value is repeated for indid >1. For indid = 255, rows is set to 0. Provided for backward compatibility.

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.