SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Steps for performance Tuning....!!!!

AceNoviceJul 28 2009 — edited Jul 28 2009

Hi all,

I need your help in Performance tuning.

While we do tuning in Oracle, apart from Indexes, where clause and order by clause, what are the other points we need to check. I mean explain plan etc...

I am working as Informatica Developer, but i need to make an documents which points out what are the step we can check while doing performance tuning on SQL queries.

Thanks in advance for your help.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 25 2009

Added on Jul 28 2009

1 comment

623 views