Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: performance impact of index
Even when the Optmizer choose NOT to use these indexes, it is still no
slower than full table scan, right?
"Sybrand Bakker" <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote in
message news:7desa05e654uq455h02a9pcp33iq9l189u_at_4ax.com...
> On Fri, 21 May 2004 10:48:07 -0400, "Gordon" <gordon_t_wu_at_hotmail.com>
> wrote:
>
> >Hi,
> >
> >I have a schema which is highly denormalized and purely read-only. For
the
> >purpose of fast data access, is there any reason not to create a bitmap
> >index on every field for every table?
> >
> >Gordon
> >
>
> There is every reason NOT to do this, as the optimizer will likely not
> use most of these indexes AT ALL, or it will choose the WRONG index.
> What makes you think this will get you 'fast data access'. Do you
> subscribe to the 'avoid full table scans at all cost, and index
> everything' myth? It doesn't work, as it is a myth.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Fri May 21 2004 - 13:04:05 CDT
![]() |
![]() |