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: 64152
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: Sat Dec 10 22:11:23 CST 2016

Total time taken to generate the page: 0.08351 seconds