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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course MySQL: Views, Indices, & Normal Forms
Likes 40 Likes 40  
Channel SQL Database Administration
Likes 384 Likes 384  
Channel Wintellect SQL Server
Likes 1 Likes 1  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)
Likes 268 Likes 268  
Course Establishing Team Goals and Responsibilities, and Using Feedback Effectively
Likes 1245 Likes 1245  
Course SQL Tuning
Likes 30 Likes 30