Oracle SQL Querie Timings [message #4661] |
Mon, 06 January 2003 09:29 |
Richard
Messages: 44 Registered: May 2000
|
Member |
|
|
Hello,
I have used the following in Oracle for performance testing:
set termout off
spool h:test.lst
timing start
Select /*+ ORDERED USE_NL(product) */
product.description, product.price, customer.unique1, customer.unique2, customer.two, customer.four, customer.ten, customer.twenty, customer.onepercent, customer.tenpercent, customer.twentypercent, customer.fiftypercent, customer.unique3
From customer, product
Where customer.unique1=product.unique1
AND customer.onepercent=1;
timing stop
spool off
set termout on
but the results returned are not as expected in pure mins and secs. I get results like - 00:09:576.95
What does this mean! Thanks in advance - Please email me back richard_nickless@btinternet.com
|
|
|
|