Displays the index metadata for the given index. You can optionally restrict the output to only those indexes on a specified table, and to only those indexes belonging to a specified owner.
dbo.sp_iqindexmetadata {'index-name'
[ , 'table-name' [ , 'owner-name' ] ] }
DBA authority or EXECUTE permission required.
“sp_iqindex and sp_iqindex_alt procedures”, “sp_iqindexfragmentation procedure”, “sp_iqindexinfo procedure”, and “sp_iqindexsize procedure”
Chapter 5, “Working with Database Objects” in the Sybase IQ System Administration Guide
Specifying a table name limits output to those indexes belonging to that table. Specifying an owner name limits output to indexes owned by that owner. Omitted parameters default to NULL. You can specify only one index per procedure.
The first row of output is the owner name, table name, and index name for the index.
Subsequent rows of output are specific to the type of index specified.
Index type |
Metadata returned |
|---|---|
CMP, DATE, DTTM, TIME |
Type, Version |
FP |
Type, Version, LookupPages, Style, LookupEntries, 1stLookupPage, LargeLOBs, SmallLOBs, IQ Unique, LOB Compression (only if column data type is long VARCHAR or long BINARY) |
HG |
Type, Version, Distinct Keys |
HNG |
Type, Version, BitsPerBlockmap, NumberOfBits |
LD |
Type, Version<ld>, Version, Distinct Keys |
LF |
Type, Version, IndexStatus, NumberOfBlockmaps, BitsPerBlockmap, Distinct Keys |
WD |
Type, Version, KeySize, Delimiters, DelimiterCount, MaxKeyWordLength, PermitEmptyWord |
The following command displays index information about the HG index hg_index_col54:
sp_iqindexmetadata 'hg_index_col54' , 'metal' , 'DBA';
'DBA', |
'metal' |
'hg_index_col54' |
'Type', |
'HG', |
'' |
'Version', |
'2', |
'' |
'Distinct Keys', |
'0', |
'' |
