understanding clustering_factor and leaf_blocks
hello gurus,
I try to understand if my tablespaces are not very good organized.
i executed a query to retrieve all my indexes the number of CLUSTERING_FACTOR and of LEAF_BLOCKS.
if i understand a little that is meaning that for retrieve information of my table by the indexes, i have to access a high number time access disk therefor i have to reorganize my table and my indexe, by exemple below :
the table name is PA_IND_COMPILED_SETS this indexe is PA_IND_COMPILED_SETS_N1 the clustering factor is : 1,077,550 and LEAF_BLOCKS 43,317.
therefore i have to export and import this table and index !!!!