Members   Search   Help    Register    Login   Home
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: 162
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
Report message to a moderator
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: 28991
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Query the plan.
Database Performance Tuning Guide.

Regards
Michel
Report message to a moderator
Previous Topic:import table having 30000000 rows
Next Topic:Performance tuning
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 8 18:09:29 CST 2009

Total time taken to generate the page: 6.99601 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.