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

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: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
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: Mon Nov 25 16:53:20 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.