SQL results in ST05

flvia_s — Thu, 09 Aug 2007 00:24:01 GMT

Hi, experts.

I'm using ST05 to see how long a join is taking, but each time I trace it, I get a different value. Not a small difference, some times it's near 30.000 and other times near 2.000.000.

What should I do to get a precisely result?

Thanks in advance,

Flávia

Re: SQL results in ST05

Former Member — Thu, 09 Aug 2007 00:39:15 GMT

Well,It varies depend upon database load,sometime operation on database table is less then this time you get less time other times you may get diffrent time.

Best thing would be copy only join code and paste it into one dummy program ,run it as background. here you get some what accurate results.

if it devlopment system then copy and paste otherwise do not work on this.

Thanks

Seshu

topic SQL results in ST05 in Application Development and Automation Discussions

SQL results in ST05

Re: SQL results in ST05