Re: SQL with no output

ed.prochak_at_magicinterface.com (Ed prochak) wrote:

>Exactly what are you trying to benchmark?

Executing exact the same SQLs after having made changes to the schema or init parameters.

>One way to deal with the overhead when benchmarking is to make it
>consistent.

That's why I am asking how to suppress output!

>But in the end you seem to be interested in a DOS solution. Try asking
>in a Microsoft group how to execute a command in a DOS window,
>minimized (that way the "screen update" issue is bypassed).

sqlplus on DOS can also spool into a file... Since the amount of data returned by the queries could be surprisingly large, spooling would produce unnecesary junk files and could impact elapsed time.

Bye
Rick Denoire Received on Fri Nov 21 2003 - 19:19:21 CST