Oracle Accessing Tables, Types o table access
02 Oracle Optimizer and its execution plan
Oracle Optimizer and its execution plan, cost based optimizer, execution plan. statistics, SQL tuning tools
01 Oracle SQL Tuning Intro
Prerequisites for SQL Tuning You will need to know the following to make use of this article Familiarity with database architecture: This means how oracle stores data, how it retrieves the data and how it produces the result set. Knowledge of SQL : what tables to use, when to join each table and how to join tables... Continue Reading →