Re: analyze index

Richard Foote wrote:

> Hi Holger
>
> Actually, it doesn't need to visit the table in order to calculate the CF as
> it has all the info it needs within the rowids contained in the index.
>
> Basically, as it reads through the rowids in the leaf pages, if the block id
> (or of course file no) changes from one index entry to the next, the CF is
> incremented. If consecutive index entries point to the same block, the CF is
> not incremented.
>
> Cheers
>
> Richard

Wake up every morning and learn something new. Life is good.

Thanks.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)