ADVISE_INDEX
FieldTypeDescription
EXPLAIN_REQUESTERstringExplain Requester
EXPLAIN_TIMEdatetimeExplain Time
SOURCE_NAMEstringSource Name
SOURCE_SCHEMAstringSource Schema
SOURCE_VERSIONstringSource Version
EXPLAIN_LEVELstringExplain Level
STMTNOintegerStmtno
SECTNOintegerSectno
QUERYNOintegerQueryno
QUERYTAGstringQuerytag
NAMEstringName
CREATORstringCreator
TBNAMEstringTbname
TBCREATORstringTbcreator
COLNAMEStextColnames
UNIQUERULEstringUniquerule
COLCOUNTintegerColcount
IIDintegerIid
NLEAFbigintNleaf
NLEVELSintegerNlevels
FIRSTKEYCARDbigintFirstkeycard
FULLKEYCARDbigintFullkeycard
CLUSTERRATIOintegerClusterratio
CLUSTERFACTORdoubleClusterfactor
USERDEFINEDintegerUserdefined
SYSTEM_REQUIREDintegerSystem Required
CREATE_TIMEdatetimeCreate Time
STATS_TIMEdatetimeStats Time
PAGE_FETCH_PAIRSstringPage Fetch Pairs
REMARKSstringRemarks
DEFINERstringDefiner
CONVERTEDstringConverted
SEQUENTIAL_PAGESbigintSequential Pages
DENSITYintegerDensity
FIRST2KEYCARDbigintFirst2Keycard
FIRST3KEYCARDbigintFirst3Keycard
FIRST4KEYCARDbigintFirst4Keycard
PCTFREEintegerPctfree
UNIQUE_COLCOUNTintegerUnique Colcount
MINPCTUSEDintegerMinpctused
REVERSE_SCANSstringReverse Scans
USE_INDEXstringUse Index
CREATION_TEXTtextCreation Text
PACKED_DESCblobPacked Desc
RUN_IDdatetimeRun Id
INDEXTYPEstringIndextype
EXISTSstringExists
RIDTOBLOCKstringRidtoblock
AVGPARTITION_CLUSTERRATIOintegerAvgpartition Clusterratio
AVGPARTITION_CLUSTERFACTORdoubleAvgpartition Clusterfactor
AVGPARTITION_PAGE_FETCH_PAIRSstringAvgpartition Page Fetch Pairs
DATAPARTITION_CLUSTERFACTORdoubleDatapartition Clusterfactor
NULLKEYSstringNullkeys