Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: query's explain plan different in 8i and 9i?

Re: query's explain plan different in 8i and 9i?

From: --- <---_at_noddy.land>
Date: Wed, 22 Oct 2003 03:13:07 GMT
Message-ID: <7Bmlb.160775$bo1.35394@news-server.bigpond.net.au>

"G M" <zlmei_at_hotmail.com> wrote in message news:50a5e6b6.0310211655.73df6466_at_posting.google.com...
> Hi:
>
> I found that a query worked quite well on Oracle 8173 is running very slow
> on Oracle 9i.
> I doubled check init paramters and they are the same. The table involved
> has about 20M rows. The tables has been analyzed in both cases. Is there
> any thing I should look or set in 9i so that query can run as fast as 8i?
> Better yet, what could be the reason that this query is using "BITMAP"
> instead of regular index range scan? TIA.
>

Have the indexes been created as bitmap in the 9i instance? Received on Tue Oct 21 2003 - 22:13:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US