Topic outline
- Optimizing SQL Queries
Optimizing SQL Queries
Task: Identify slow SQL queries and optimize them.
Approach: Demonstrate using query plan, Index Analyzer, runtime stats, etc., to identify slow SQL queries. Then show how to make then faster using Tune Table, indices, %Parallel, SQL hints, and frozen plan, etc.
Presenter: Anton Umnikov