Home » RDBMS Server » Performance Tuning » Comparing Hints
Comparing Hints [message #185868] Thu, 03 August 2006 22:25 Go to next message
hari_bk
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?

Thanks

Report message to a moderator

Re: Comparing Hints [message #185885 is a reply to message #185868] Fri, 04 August 2006 00:58 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Yes you can. Start sqlplus, SET AUTOTRACE ON, run both the queries several times and summarize the results.

Report message to a moderator

Previous Topic: how to reduce using virtual memeory
Next Topic: Looking for optimizations for Oracle DB
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 19:14:42 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.