Re: Turn statement results off

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Fri, 22 Jun 2001 11:48:53 +0100
Message-ID: <993206880.1925.0.nnrp-12.c30bdde2@news.demon.co.uk>

Look here:
SQL> set autotrace
Usage: SET AUTOT[RACE] {OFF | ON | TRACE[ONLY]} [EXP[LAIN]] [STAT[ISTICS]] SQL> If you do set autotrace trace exp stat, it will run the query but not return the results and show you the plan/time etc.

"Joshua Goodstein" <awing_pilot_at_yahoo.com> wrote in message news:924a90f8.0106211709.6796830c_at_posting.google.com...
> 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
Received on Fri Jun 22 2001 - 05:48:53 CDT