Re: Query performance problem

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 8 Dec 1999 07:49:09 -0000
Message-ID: <944639501.5687.1.nnrp-02.9e984b29@news.demon.co.uk>

An important point to consider:

If you are running first_row optimisation, then shift the SQL into a PL/SQL block all code inside PL/SQL runs with CHOOSE optimisation - which will effectively mean all_row optimisation.

So if you are running the database in first_row, always include this hint in any SQL that you package up.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

dmausner_at_ameritech. .net (dave mausner) wrote in message ...
>
>try hinting where you want the query to run (target_site hint) and anything
>else that the good optimization benefits from (index hints). also select an
>optimizer strategy (first_rows hint, e.g.).
>
Received on Wed Dec 08 1999 - 01:49:09 CST