Home » RDBMS Server » Performance Tuning » Which Performance hint we should use when?
Which Performance hint we should use when? [message #311098] Thu, 03 April 2008 07:05 Go to next message
manoj12
Messages: 185
Registered: March 2008
Location: India
Senior Member
Dear Michel

Could you please tell me which performmance hint we should use when?
Re: Which Performance hint we should use when? [message #311101 is a reply to message #311098] Thu, 03 April 2008 07:13 Go to previous messageGo to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
well
all i can say is depends.
but still
----- never use calculationsat left side like
where  a * 2 + 5 > 13 ;

instead
 where a > 13-5/2. 

-- second try to use < and > as less as possible.
-- dont apply formula or calculations on inexed columns.
like if index on column mdate
then avoid
  where to_char(mdate,'xxxxxx') = 'xxxxxx' 

etc.
thats all i have in my mind

[Updated on: Thu, 03 April 2008 07:13]

Report message to a moderator

Re: Which Performance hint we should use when? [message #311102 is a reply to message #311098] Thu, 03 April 2008 07:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First this is OraFAQ and not AskMichel so post your question to the whole community.

Then all what I could say is in:
- Database Performance Tuning Guide
- OraFAQ Oracle SQL Tuning Guide
and other things you'll find in How to Identify Performance Problem and Bottleneck

Regards
Michel



Re: Which Performance hint we should use when? [message #311108 is a reply to message #311102] Thu, 03 April 2008 07:30 Go to previous message
manoj12
Messages: 185
Registered: March 2008
Location: India
Senior Member
Thanks for your reply
Previous Topic: How to decrease time to execute SUM function?
Next Topic: update takes much time to execute
Goto Forum:
  


Current Time: Mon Dec 05 21:33:10 CST 2016

Total time taken to generate the page: 0.11351 seconds