Re: What is a good blocksize to use.

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:anac26$jb0$1$8300dec7_at_news.demon.co.uk...
>
> The secondary index entry consists of:
> {foreign key columns} {primary key} {block guess}
>
> But I never ever managed to get Oracle to use
> the {block guess} to locate a row in an IOT -
> every test I did showed it traversing the {primary key}
> (whatever the manuals might say).
>
> Has anyone ever seen a secondary index use a
> guess ? (at least in 8.1, I haven't tested 9.2 yet).
>
>

That's my experience, too, Jonathan: every time, a lookup by primary key.

And this is 9iR2.

Regards
HJR
> --
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
Received on Mon Sep 30 2002 - 15:38:55 CDT