The sysindexes table stores information about indexed and nonindexed tables. sysindexes has one row for each:
Allpages-locked table – the indid column is 0 if the table does not have a clustered index, and 1 if the table does have a clustered index.
Data-only-locked tables – the indid is always 0 for the table.
Nonclustered index – and for each clustered index on a data-only-locked table.
Table with one or more LOB columns – the index ID is always 255 for the LOB structure.
syspartitions stores information about each table and index partition and includes one row per partition.
In Adaptive Server version 15.0. and later, each row in syspartitions stores pointers to a table or index to speed access to objects. Table 2-2 shows how these pointers are used during data access.
Column |
Use for table access |
Use for index access |
|---|---|---|
root |
If indid is 0 and the table is a partitioned allpages-locked table, root points to the last page of the heap. |
Used to find the root page of the index tree. |
first |
Points to the first data page in the page chain for allpages-locked tables. |
Points to the first leaf-level page in a nonclustered index, or a clustered index on a data-only-locked table. |
doampg |
Points to the first OAM page for the table. |
|
ioampg |
Points to the first OAM page for an index. |
