Home » RDBMS Server » Performance Tuning » Comparing Hints
Comparing Hints [message #185868] Thu, 03 August 2006 22:25 Go to next message
Messages: 110
Registered: March 2006
Senior Member
Hi How to see the diffrence in terms of resources or response time between ALL_ROWS and FIRST_ROWS hints? Can we track the diffrence anywhere?

Re: Comparing Hints [message #185885 is a reply to message #185868] Fri, 04 August 2006 00:58 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Yes you can. Start sqlplus, SET AUTOTRACE ON, run both the queries several times and summarize the results.
Previous Topic: how to reduce using virtual memeory
Next Topic: Looking for optimizations for Oracle DB
Goto Forum:

Current Time: Mon Oct 24 00:21:19 CDT 2016

Total time taken to generate the page: 0.11759 seconds