Tag Archives: Oracle

12 Oracle Design Consideration


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

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,

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

01 Oracle SQL Tuning Intro


Prerequisites for SQL Tuning You will need to know the following to make use of this article Familiarity with database architecture: This means how oracle stores data, how it retrieves the data and how it produces the result set. Knowledge of SQL : what tables to use, when to join each table and how to join tables […]
Read More »