Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query Runs faster in 10G
Thanks Frank,
I have been assigned the task to optimise this query on 8i. I would really appreciate any suggestions.
-Ron
> Apart from the obvious "yet another reason to upgrade to 10g", your
> execution plans differ. One, because ALL_ROWS is the goal in 10g, and
> CHOOSE in 8i.
> Don't recall if ALL_ROWS appears in an explain plan unless it it set,
> either at instance, or at session level.
>
> --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...
Received on Fri Mar 03 2006 - 15:11:19 CST