Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SQL results in ST05

Go to solution
flvia_s
Participant

‎08-09-2007 1:24 AM

0 Kudos

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

1 ACCEPTED SOLUTION

Go to solution
Former Member

‎08-09-2007 1:39 AM

0 Kudos

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

1 REPLY 1

Go to solution
Former Member

‎08-09-2007 1:39 AM

0 Kudos

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