Question about analyzing SQL statements

From: Adam Sandler <corn29_at_excite.com>
Date: Wed, 31 Oct 2007 08:07:26 -0700
Message-ID: <1193843246.788022.46910@50g2000hsm.googlegroups.com>

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! Received on Wed Oct 31 2007 - 10:07:26 CDT