Home » RDBMS Server » Performance Tuning » Parallel and First_rows Hints
Parallel and First_rows Hints [message #409589] Tue, 23 June 2009 04:08 Go to next message
vikram1780
Messages: 222
Registered: January 2007
Location: Bangalore
Senior Member
Hi,

I have used above hints in my sql qury and found no difference in execution time.

I just want to know whether the hints are used in my sql are not.


Could you please let me know where to check for it.


Thanks in advance
Re: Parallel and First_rows Hints [message #409610 is a reply to message #409589] Tue, 23 June 2009 05:29 Go to previous message
Michel Cadot
Messages: 64455
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Query the plan.
Database Performance Tuning Guide.

Regards
Michel
Previous Topic: import table having 30000000 rows
Next Topic: Performance tuning
Goto Forum:
  


Current Time: Fri Feb 24 13:42:50 CST 2017

Total time taken to generate the page: 0.06460 seconds