File Library

Hands-on Training: How to Prevent Suboptimal Execution Plans
Topic: The Database
Owner: Maria Colgan
Date: 2013-05-24
Subtopic: Tips and Techniques

This session shows the process of analyzing and resolving the most common SQL execution performance problems including, poor cardinality estimations, bind peeking issues, selecting the wrong access method, and more. You will learn how to identify and quickly resolve these issues and develop a toolkit of queries and techniques to determine the root cause of any plan regression.

Download File   MColgan.Hands_on_training.pdf

Become a member of ODTUG to gain access to more than 12,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database

Click here to see the Full Techincal Resource Database