Overview:

• Discuss steps for optimizing

• Discuss the output of the Set Explain command

• Discuss Indexing Strategies

• New SQL in OnLine Dynamic Server (IDS 7.3)

• Table Scans & Table Joins

• Optimizer Directives (IDS 7.3)

• Discuss optimization techniques and examples

• XTREE command

• Correlated Sub-Queries (IDS 7.3)

Previous slide

Next slide

Back to first slide

View graphic version