OraFAQ Forum: Performance Tuning » how to change clustering factor

Home » RDBMS Server » Performance Tuning » how to change clustering factor (oracle 9i aix5)

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

how to change clustering factor [message #386391]

Sat, 14 February 2009 05:30

reyazan
Messages: 53
Registered: February 2005

Member

i am using oracle 9i on aix 5
HOW TO CHANGE CLUSTERING FACTOR

PLS REPLY

Report message to a moderator

Re: how to change clustering factor [message #386399 is a reply to message #386391]

Sat, 14 February 2009 09:05

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you

GOOGLE is your friend, but only when you actually use it.
Results 1 - 10 of about 225,000 for oracle cluster factor.

>HOW TO CHANGE CLUSTERING FACTOR
Why do you think it should be changed?
How do you decided what the "proper/desired" value should be?

Report message to a moderator

Re: how to change clustering factor [message #386400 is a reply to message #386391]

Sat, 14 February 2009 09:10

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

Senior Member
Account Moderator

Quote:

HOW TO CHANGE CLUSTERING FACTOR

1/ dont post in UPPER case
2/ Reorder the rows.

Regards
Michel

Report message to a moderator

Re: how to change clustering factor [message #386426 is a reply to message #386400]

Sat, 14 February 2009 16:25

gintsp
Messages: 118
Registered: February 2007

Senior Member

Michel Cadot wrote on Sat, 14 February 2009 17:102

Reorder the rows.

And don't forget that clustering factor of only __one__ index can be made perfect.

[Updated on: Sat, 14 February 2009 16:27]

Report message to a moderator

Re: how to change clustering factor [message #386427 is a reply to message #386391]

Sat, 14 February 2009 16:38

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>And don't forget that clustering factor of only __one__ index can be made perfect.
How do you decide what the "perfect" value should be?
What happens when the clustering factor is not perfect?

Report message to a moderator

Re: how to change clustering factor [message #386631 is a reply to message #386391]

Mon, 16 February 2009 05:18

Alessandro Rossi
Messages: 166
Registered: September 2008
Location: Rome

Senior Member

That subject is completely and perfectly explained here

Bye Alessandro

Report message to a moderator

Previous Topic:	Inserts to table very slow
Next Topic:	re-write the query to improve performance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 07:57:35 CST 2024