Tuning your apps
Bring me home...
Query tuning
Merge join and index full scan
Selectivity, Histograms and bind variables
Bind variables and stored outlines?
Outer join and index
Tune full outer join
Union view over partitioned tables
Function based index
Inlist iterator vs. Concatenation
IN and NOT IN
Bitmap indexes
Restrictions and tips
The basics
Bitmap join index
BJI on a snow flake schema
BJI maintainence
Execution plan of a snow flake/BJI
Event tracing
Trace analyzer
Identify wait events with event 10046 tracing
Understand CBO decision making process with event 10053 tracing
Plan stability with stored outlines
The basics
Strange case 1: what if index is missing?
Strange case 2: what if index is added?
Strange case 3: what if table is recreated after outlines have been generated?
Strange case 4: what if table structure render the query invalid?