Home » RDBMS Server » Performance Tuning » how to change clustering factor (oracle 9i aix5)
how to change clustering factor [message #386391] Sat, 14 February 2009 05:30 Go to next message
reyazan
Messages: 53
Registered: February 2005
Member
i am using oracle 9i on aix 5
HOW TO CHANGE CLUSTERING FACTOR

PLS REPLY
Re: how to change clustering factor [message #386399 is a reply to message #386391] Sat, 14 February 2009 09:05 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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?
Re: how to change clustering factor [message #386400 is a reply to message #386391] Sat, 14 February 2009 09:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
HOW TO CHANGE CLUSTERING FACTOR

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

Regards
Michel
Re: how to change clustering factor [message #386426 is a reply to message #386400] Sat, 14 February 2009 16:25 Go to previous messageGo to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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?

Re: how to change clustering factor [message #386631 is a reply to message #386391] Mon, 16 February 2009 05:18 Go to previous message
Alessandro Rossi
Messages: 166
Registered: September 2008
Location: Rome
Senior Member
That subject is completely and perfectly explained here

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


Current Time: Wed Dec 07 10:52:28 CST 2016

Total time taken to generate the page: 0.20223 seconds