Re: how to measure parsing and execution time ?

From: Edward J. Prochak <ed.prochak_at_magicinterface.com>
Date: Mon, 18 Nov 2002 16:16:15 GMT
Message-ID: <3DD91513.40601@magicinterface.com>

sharkphobia wrote:
> Hi,
> I would like to estimate the time gained by having two SQL statements
> parsed and executed twice versus parsed once and executed twice.
>
> Any one who could illuminate me on this ?
>
> thanks in advance,
>
> Sharkphobia

Look up how to run TKPROF. It can provide the statistics you need.

HTH

-- 
Edward J. Prochak   --- Magic Interface, Ltd.
Ofc: 440-498-3700   --- 7295 Popham Place, Solon, OH 44139
on the web at       --- http://www.magicinterface.com
email: ed.prochak_at_magicinterface.com

Received on Mon Nov 18 2002 - 10:16:15 CST