Re: Question about analyzing SQL statements

On Wed, 31 Oct 2007 08:07:26 -0700, Adam Sandler <corn29_at_excite.com> wrote:

>Hello,
>
>Quite some time ago, a former colleague introduced a feature/
>capability of Oracle to me where a developer can see how their SQL
>statements are processed by the DB... which clauses are evaluated
>first, how things are run, orders of operations, etc. He mentioned
>there was even a whole book (I'm sure there's more than one; I just
>don't know where to start searching) about this capability.
>
>The problem is, I don't know what specifically this capability is
>called. And since I'm not using the correct jargon, Google searches
>aren't panning out (understandably so).
>
>I've got a rather involved SQL statement which is running very slow.
>I'd like to see how the DB is processing it and see if I can modify
>the SQL to increase performance.
>
>Thanks!

The term is optimization. A good place to start would be with "EXPLAIN PLAN". It is a statement. Or, in SQLPlus there is an option to automatically show explain plans.

B. Received on Wed Oct 31 2007 - 10:10:51 CDT