Tuning Problem SQL Statements

Oracle 12c    |    Intermediate
  • 13 Videos | 48m 26s
  • Includes Assessment
  • Earns a Badge
Likes 21 Likes 21
SQL is at the heart of any relational database management system, and optimizing SQL typically provides the largest performance gains in real-world situations. Explore the Cost-Based Optimizer and optimizing data retrieval.

WHAT YOU WILL LEARN

  • describe the tasks of the query optimizer during SQL parsing
    describe the concepts of selectivity, cardinality and cost
    describe statistics used by the optimizer
    list the database parameters which influence the behaviour of the optimizer
    describe adaptive and dynamic execution plans
    describe the cardinality feedback feature
    describe how manipulating the optimizer_mode parameter affects SQL operations
  • describe the ways in which data is retrieved from the database
    describe the most commonly used index access paths
    describe the concept of join operations
    list the types of join operations used by the optimizer
    describe the conditions under which each join operation works best
    describe the basics of sorting and briefly touch on tuning sort performance

IN THIS COURSE

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 23 Likes 23  
Likes 33 Likes 33