|
View previous topic :: View next topic
|
| Author |
Message |
chavinash2004
New User
Joined: 30 Jun 2010
Posts: 37
Location: hyderabad
|
|
|
|
Hi,
I have to queries which is written by me for the same requirement in two models.But i want to know the performance of the query which will execute fast.How to calculate the time taken by each query.
I executed the query in SPUFI.I search in this forum but i did not find it.So please give me the solution for this.Thanks in advance........................ |
|
| Back to top |
|
 |
chandracdac
New User
Joined: 15 Jun 2007
Posts: 92
Location: bangalore
|
|
|
|
| Using QMF we can check this.. try it |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
or use explain and expand your plan_table query to include DSN_STATEMENTS.
all the key words that I used are easily found in the sql references. |
|
| Back to top |
|
|
|
|
