SQL Performance (MOSC)

MOSC Banner

understanding clustering_factor and leaf_blocks

edited Feb 23, 2016 9:23AM in SQL Performance (MOSC) 6 commentsAnswered

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 !!!!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center