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
Messages: 222
Registered: January 2007
Location: Bangalore
Senior Member

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: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Query the plan.
Database Performance Tuning Guide.

Previous Topic: stale or empty statiscs
Next Topic: Performance tuning
Goto Forum:

Current Time: Sun Aug 20 12:21:30 CDT 2017

Total time taken to generate the page: 0.06391 seconds