OraFAQ Forum: Performance Tuning » Which Performance hint we should use when?

Home » RDBMS Server » Performance Tuning » Which Performance hint we should use when?

Thu, 03 April 2008 07:05

manoj12
Messages: 210
Registered: March 2008
Location: India

Senior Member

Dear Michel

Could you please tell me which performmance hint we should use when?

Thu, 03 April 2008 07:13

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]

Thu, 03 April 2008 07:15

Michel Cadot
Messages: 68665
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

Thu, 03 April 2008 07:30

manoj12
Messages: 210
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: Fri Jun 28 12:44:09 CDT 2024