1. Oracle SQL Tuning

    • Buy now
    • Learn more

  2. Course Materials

    • Slides
    • Lab Guide

  3. SQL Performance Fundamentals

    • SQL Performance Fundamentals

  4. Optimizer Fundamentals

    • SQL Processing
    • Optimizer Concepts

  5. Execution Plans

    • About Execution Plans
    • Reading Execution Plans
    • Generating Execution Plans using SQL*Plus AUTOTRACE
    • Generating Execution Plans using EXPLAIN PLAN

  6. Access Paths

    • Concepts
    • Lab Practices

  7. Join Methods

    • Concepts
    • Lab Practices

  8. Optimizer Statistics

    • About Optimizer Statistics
    • When and How Database gathers Optimizer Statistics?
    • Configuring Options for Optimizer Statistics gathering
    • Gathering Optimizer Statistics
    • Lab Practices: Gathering Optimizer Statistics
    • Histograms
    • Lab Practices: Histograms
    • Extended Statistics: Column Group Statistics
    • Extended Statistics: Expression Statistics
    • Lab Practices: Extended Statistics
    • Controlling the use of Optimizer Statistics
    • Lab Practices: Controlling the use of Optimizer Statistics

  9. Optimizer Controls

    • Using Hints
    • Lab Practices: Using Hints
    • Cursor Sharing, Adaptive Cursor Sharing

  10. SQL Monitoring

    • Monitoring SQLs

  11. SQL Tracing

    • Tracing SQLs

  12. SQL Tuning Set

    • SQL Tuning Set (STS)

  13. SQL Tuning Advisor

    • Concepts
    • Lab Practices

  14. SQL Access Advisor

    • SQL Access Advisor

  15. SQL Profiles

    • SQL Profiles

  16. SQL Plan Management (SPM)

    • Concepts
    • Lab Practices

  17. Migrating Stored Outlines

    • Migrating Stored Outlines to SQL Plan Baselines
  1. Products
  2. Course
  3. Section
  4. Lesson

SQL Performance Fundamentals

  1. Oracle SQL Tuning

    • Buy now
    • Learn more

  2. Course Materials
    • Slides
    • Lab Guide

  3. SQL Performance Fundamentals
    • SQL Performance Fundamentals

  4. Optimizer Fundamentals
    • SQL Processing
    • Optimizer Concepts

  5. Execution Plans
    • About Execution Plans
    • Reading Execution Plans
    • Generating Execution Plans using SQL*Plus AUTOTRACE
    • Generating Execution Plans using EXPLAIN PLAN

  6. Access Paths
    • Concepts
    • Lab Practices

  7. Join Methods
    • Concepts
    • Lab Practices

  8. Optimizer Statistics
    • About Optimizer Statistics
    • When and How Database gathers Optimizer Statistics?
    • Configuring Options for Optimizer Statistics gathering
    • Gathering Optimizer Statistics
    • Lab Practices: Gathering Optimizer Statistics
    • Histograms
    • Lab Practices: Histograms
    • Extended Statistics: Column Group Statistics
    • Extended Statistics: Expression Statistics
    • Lab Practices: Extended Statistics
    • Controlling the use of Optimizer Statistics
    • Lab Practices: Controlling the use of Optimizer Statistics

  9. Optimizer Controls
    • Using Hints
    • Lab Practices: Using Hints
    • Cursor Sharing, Adaptive Cursor Sharing

  10. SQL Monitoring
    • Monitoring SQLs

  11. SQL Tracing
    • Tracing SQLs

  12. SQL Tuning Set
    • SQL Tuning Set (STS)

  13. SQL Tuning Advisor
    • Concepts
    • Lab Practices

  14. SQL Access Advisor
    • SQL Access Advisor

  15. SQL Profiles
    • SQL Profiles

  16. SQL Plan Management (SPM)
    • Concepts
    • Lab Practices

  17. Migrating Stored Outlines

    • Migrating Stored Outlines to SQL Plan Baselines