Oracle Performance Tuning

01 Oracle SQL Tuning Intro

02 Oracle Optimizer and its execution plan

03 Accessing Tables

04 Explain Plan

05 Simple Tuning Rules

06 Index Suppression

07 Performance Improvement Consideration

08 Considerations while using PLSQL in programming (Oracle)

09 Oracle SQL Tuning for Join Methods

10 Oracle Hints to the Database

11 House Keeping in Oracle

12 Oracle Design Consideration