Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: The Index Clustering Factor Explained
I see what you mean. Yup, makes perfect sense.
-- Cheers Nuno Souto wizofoz2k_at_yahoo.com.au.nospam "Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:40a0c48b$0$440$afc38c87_at_news.optusnet.com.au...Received on Tue May 11 2004 - 07:38:43 CDT
> >
> > Is it possible to expand it for non-unique indexes?
>
> Not sure what you mean. The indexes used in the actual worked examples
> were non-unique (in declaration, if not in content).
>
> And the Clustering Factor calculation would not change any (ie, *how* it
> is calculated: if I follow this index entry, what table block do I have
> to visit...Oh, stone me it's the same as the last visit I made,
> therefore I won't count it etc etc).
>
![]() |
![]() |