Database Tuning (MOSC)

MOSC Banner

Ask about Clustering Factor to know index either GOOD or BAD

in Database Tuning (MOSC) 5 commentsAnswered ✓

Hi,

I have checked index statistics and read some articles related to clustering factor

So if the value of Clustering Factor near the number of blocks in the table --> the index will be useful.

If Clustering Factor near the number of rows in the table --> the index will be less efficient.

I checked my database and see lot of indexes is less efficient if follow this rule (except the row with yellow highlight is good).

Could you share your experiment about this? If they are BAD, so we should do full table scan instead of using index?

Thanks,

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