Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: why does oracle not use the index pk_emp
True enough. I forgot the segment header/extent map etc. But indexes have
segment headers and extent maps, too... so it is still (probably) the case
that the scan of the small table will be cheaper than the scan of the index
on said table.
Regards
HJR
>
> although full scanning a 1 block table sometimes takes more than just
> the 1 block for the table itself...
>
> hth
> connor
> --
> =========================
> Connor McDonald
> http://www.oracledba.co.uk
>
> "Some days you're the pigeon, some days you're the statue"
Received on Thu Mar 27 2003 - 01:53:43 CST