Oracle Performance Improvement Consideration, union vs OR, Union all vs Union, exist vs IN
07 Performance Improvement Consideration
06 Index Suppression
Index Suppression in Oracle, operators, sub-strings, Arithmetic operators, Truncate , function based index
05 Simple Tuning Rules
Simple Tuning Rules for Oracle. Where vs having, table aliases
04 Explain Plan
Oracle Explain Plan, Execution Plan,
03 Accessing Tables
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
Life Less Ordinary 