OraFAQ Forum: Performance Tuning » Clustering Factor in Index

Home » RDBMS Server » Performance Tuning » Clustering Factor in Index (Oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Clustering Factor in Index [message #486411]

Wed, 15 December 2010 07:30

vnkumaresh
Messages: 9
Registered: December 2010

Junior Member

HI All,

I am just curious to know what is clustering factor in index and How is it impartant in a sql tuning perspective ?

Thanks

Report message to a moderator

Re: Clustering Factor in Index [message #486417 is a reply to message #486411]

Wed, 15 December 2010 07:41

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

http://www.google.com/search?hl=en&source=hp&q=oracle+clustering+factor&aq=4&aqi=g10&aql=&oq=oracle+clust& ;gs_rfai=

Regards
Michel

Report message to a moderator

Re: Clustering Factor in Index [message #487321 is a reply to message #486417]

Fri, 24 December 2010 19:49

harman_deep
Messages: 8
Registered: August 2005
Location: Amritsar

Junior Member

Clustering factor in simple terms at the best is equal to number of blocks of Index .. and at worst is equal to number of rows in the table.
It is the counter which is incremented by 1 when for next entry in the index block, the new data block is hit and not incremented when the next entry is found in the same database block.

Hope it helps.

Report message to a moderator

Re: Clustering Factor in Index [message #487335 is a reply to message #487321]

Sat, 25 December 2010 01:15

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Hope it helps

I know what is a clustering factor, so I know what you say is true but I doubt anyone will understand what is clustering factor if he previously did not know what it is.
Hope I am clear. Wink

Here's an example from Tom Kyte to explain clustering factor (I doubt someone can understand what it is without an example or a schema):
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:22442713557755

Regards
Michel

Report message to a moderator

Previous Topic:	stored outline
Next Topic:	How to overcome rownum clause from select

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 01:06:07 CST 2024