Tuning Problem SQL Statements

Oracle 12c    |    Intermediate
  • 13 Videos | 54m 56s
  • Includes Assessment
  • Earns a Badge
Likes 9 Likes 9
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.

YOU MIGHT ALSO LIKE

CHANNEL Oracle RAC
Likes 35 Likes 35  
Likes 20 Likes 20  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SOLID & GRASP
Likes 3218 Likes 3218  
Likes 5 Likes 5