Considerations while using PLSQL in programming (Oracle)
08 Considerations while using PLSQL in programming (Oracle)
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
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
Life Less Ordinary 