Oracle Design Consideration, Index organized tables, partitioned tables, range partition, list partition, hash partition, composite partition
12 Oracle Design Consideration
11 House Keeping in Oracle
House keeping in Oracle: invalid optimizer statistics, buffer gets, Disk Reads
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,
Life Less Ordinary 