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?