Re: Turn statement results off

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 21 Jun 2001 22:31:58 -0700
Message-ID: <3B32D84E.BA4B510F@exesolutions.com>

Joshua Goodstein wrote:

> I remember a while a go we found a way to not display the results for
> a statement for tuning purposes.. IE. I want to see how long the
> execution takes not the returning of the rows. Does anyone have docs
> or know how on how this may be done?????? I thought it was a tag like
> echo off but i don't care if the results are 1 million or 1 row I want
> performance info on the statement execution itself
>
> Joshua Goodstein

Run EXPLAIN PLAN.

For details go to http://technet.oracle.com

I know that is not where your question was leading but it is the best answer.

Daniel A. Morgan Received on Fri Jun 22 2001 - 00:31:58 CDT