Re: Best way to tune the below query.

Instance is currently RBO. Tried CBO a while back and the performance overall was worst. Will try again when we go from Oracle 8.1.5 to 8.1.6.3 on a Solaris 2.6 box.

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

>
>You don't seem to have any stats on your tables,
>so are running RULE based optimisation.
>
>option one -
>alter session set optimizer_mode=first_rows;
>
>option two -
>analyze the tables to see what happens when
>the statistics force Oracle to choose ALL_ROWS.
>
>Really it looks as if
> full_address like '4112 DUNWOODY%'
>should be pretty selective, so might be the
>driver for the query under CBO.
>
>
>--
>Jonathan Lewis
>Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
>Practical Oracle 8i: Building Efficient Databases
>
>Publishers: Addison-Wesley
>See a first review at:
>http://www.ixora.com.au/resources/index.htm#practical_8i
>More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
>
>
Received on Fri Jan 05 2001 - 07:52:24 CST