Category Archives: Enterprise Architecture

07 Performance Improvement Consideration

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

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