to the nearest integer. This statistic is the average number of data blocks that contain rows that contain a given value for the indexed columns.CLUSTERING_FACTOR*NUMBER Indicates the amount of order of the rows in the table based on the values of the index.If the value is near the number of blocks, then the table is very well ordered. In this case, the index entries in a single leaf block tend to point to rows in the same data blocks.If the value is near the number of rows, then the table is very randomly ordered. In this case, it is unlikely that index entries in the same leaf block point to rows in the same data blocks.For bitmap indexes, this column is not applicable and is not used.STATUSVARCHAR2(8) Indicates whether a nonpartitioned index is VALID or UNUSABLENUM_ROWSNUMBER Number of rows in the indexSAMPLE_SIZENUMBER Size of the sample used to analyze the indexLAST_ANALYZEDDATE Date on which this index was most recently analyzedDEGREEVARCHAR2(40) Number of threads per instance for scanning the indexINSTANCESVARCHAR2(40) Number of instances across which the indexes to be scannedPARTITIONEDVARCHAR2(3) Indicates whether the index is partitioned (YES) or not (NO)TEMPORARYVARCHAR2(1) Indicates whether the index is on a temporary tableGENERATEDVARCHAR2(1) Indicates whether the name of the index is system generated (Y) or not (N)SECONDARYVARCHAR2(1) Indicates whether the index is a secondary object created by theODCIIndexCreate method of the Oracle Data Cartridge (Y) or not (N)BUFFER_POOLVARCHAR2(7) Name of the default buffer pool to be used for the index blocksUSER_STATSVARCHAR2(3) Indicates whether statistics were entered directly by the user (YES) or not (NO)DURATIONVARCHAR2(15) Indicates the duration of a temporary table:SYS$SESSION - Rows are preserved for the duration of the sessionSYS$TRANSACTION - Rows are deleted after COMMITNull for a permanent tablePCT_DIRECT_ACCESSNUMBER For a secondary index on an index-organized table, the percentage of rows with VALID guessITYP_OWNERVARCHAR2(30) For a domain index, the owner of the indextypeITYP_NAMEVARCHAR2(30) For a domain index, the name of the indextypePARAMETERSVARCHAR2(1000) For a domain index, the parameter stringGLOBAL_STATSVARCHAR2(3) For partitioned indexes, indicates whether statistics were collected by analyzing the index as a whole (YES) or were estimated from statistics on underlying index partitions and subpartitions (NO)DOMIDX_STATUSVARCHAR2(12) Status of the domain index:NULL - Index is not a domain indexVALID - Index is a valid domain indexIDXTYP_INVLD - Indextype of the domain index is invalidDOMIDX_OPSTATUSVARCHAR2(6) Status of the operation on the domain index:NULL - Index is not a domain indexVALID - Operation performed without errorsFAILED - Operation failed with an errorFUNCIDX_STATUSVARCHAR2(8) Status of a function-based index:NULL - Index is not a function-based indexENABLED - Function-based index is enabledDISABLED - Function-based index is disabledJOIN_INDEXVARCHAR2(3) Indicates whether the index is a join index (YES) or not (NO)IOT_REDUNDANT_PKEY_ELIMVARCHAR2(3) Indicates whether redundant primary key columns are eliminated from secondary indexes on index-organized tables (YES) or not (NO)DROPPEDVARCHAR2(3) Indicates whether the index has been dropped and is in the recycle bin (YES) or not (NO); null for partitioned tablesMas nao sao somente esses fatores que impactam neste caso, a analise sobre essa situacao deve ser bem mais criteriosa, a criacao de indices ajudara? SIM, e muito, principalmente se eles forem baseados