Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: The Index Clustering Factor Explained

Re: The Index Clustering Factor Explained

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Tue, 11 May 2004 22:38:43 +1000
Message-ID: <40a0ca4b$0$4967$afc38c87@news.optusnet.com.au>


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...

> >
> > 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).
>
Received on Tue May 11 2004 - 07:38:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US