| TABLENAME |
Table name |
CHAR |
128 |
0 |
|
MSSTABLE
|
|
| OBJECTID |
Object id |
INT4 |
10 |
0 |
|
MSSOBJID
|
|
| INDEXNAME |
Index name |
CHAR |
128 |
0 |
|
MSSINDEX
|
|
| INDEXID |
Index id |
INT2 |
5 |
0 |
|
MSSINDEXID
|
|
| LEVEL |
Index level |
INT4 |
10 |
0 |
|
MSSINDLEVEL
|
|
| PAGES |
Number of pages in index level |
DEC |
16 |
0 |
|
MSSILPAGES
|
|
| ROWS |
Number of data or index rows in index level |
DEC |
16 |
0 |
|
MSSILROWS
|
|
| ROWMINLEN |
Minimum row size in index level |
INT4 |
10 |
0 |
|
MSSILROWMINLEN
|
|
| ROWMAXLEN |
Maximum row size in index level |
INT4 |
10 |
0 |
|
MSSILROWMAXLEN
|
|
| ROWAVGLEN |
Average row size in index level |
DEC |
12 |
2 |
|
MSSILROWAVGLEN
|
|
| FORWARDEDROWS |
Number of forwarded rows in index level |
DEC |
16 |
0 |
|
MSSILFWDROWS
|
|
| EXTENTS |
Number of extents in index level |
DEC |
16 |
0 |
|
MSSILEXTENTS
|
|
| EXTENTSWITCHES |
Number of extent switches |
DEC |
16 |
0 |
|
MSSEXTSWITCHES
|
|
| AVGFREEBYTES |
Average number of bytes free per page |
DEC |
6 |
2 |
|
MSSAVGFREEBYTES
|
|
| AVGPAGEDENSITY |
Average page density |
DEC |
5 |
2 |
|
MSSAVGPGDENSITY
|
|
| SCANDENSITY |
Scan density |
DEC |
5 |
2 |
|
MSSSCANDENSITY
|
|
| BESTCOUNT |
Ideal number of extent changes |
DEC |
16 |
0 |
|
MSSBESTCOUNT
|
|
| ACTUALCOUNT |
Actual number of extent changes |
DEC |
16 |
0 |
|
MSSACTCOUNT
|
|
| LOGICALFRAG |
Logical scan fragmentation |
DEC |
5 |
2 |
|
MSSLOGSCANFRAG
|
|
| EXTENTFRAG |
Extent scan fragmentation |
DEC |
5 |
2 |
|
MSSEXTSCANFRAG
|
|