Tag Archives: Oracle

12 Oracle Design Consideration


Oracle Design Consideration, Index organized tables, partitioned tables, range partition, list partition, hash partition, composite partition

Advertisements

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