Re: analyze index

From: Richard Foote <richard.foote_at_bigpond.nospam.com>
Date: Wed, 26 Jan 2005 11:36:02 GMT
Message-ID: <CgLJd.135403$K7.111702@news-server.bigpond.net.au>

"DA Morgan" <damorgan_at_x.washington.edu> wrote in message news:1106679084.34423_at_yasure...
> 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.
>

Hi Daniel,

I kinda wake up every morning, stumble around for a quite a while, eventually get the kids to school and myself to work, have a couple of cappuccinos to get all systems online and hopefully, all being well, I'm finally in a condition to learn something new by early afternoon.

Cheers ;)

Richard Received on Wed Jan 26 2005 - 05:36:02 CST