Category Archives: Enterprise Architecture

07 Performance Improvement Consideration


Oracle Performance Improvement Consideration, union vs OR, Union all vs Union, exist vs IN

Advertisements

06 Index Suppression


Index Suppression in Oracle, operators, sub-strings, Arithmetic operators, Truncate , function based index

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