Topic outline

  • 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

    Download PDF     View Session Recording