Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> clustering factor
I use Oracle 8.0.6 with SAP R/3. I have a lot of indexes with big
values for "clustering factor" (998745 for an index of about 12 million
rows). I remember i've read something on this item and it has something
to do with performance.
I don't remember what this means and i've never found further
explaination on it since this moment.
Could someone explain
1. what it has to do with performance problem (if it has) ? 2. what is bad ? a big number or a little one ? 3. How can i solve it ?
Regards,
-- Thierry HUGE AIX/Oracle/SAP Administrator STEELCASE STRAFOR (FRANCE) Sent via Deja.com http://www.deja.com/ Before you buy.Received on Sun Dec 10 2000 - 16:42:03 CST