Tuning Problem SQL Statements

Oracle 12c    |    Intermediate
  • 13 videos | 48m 26s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 9 users Rating 4.4 of 9 users (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

  • Locked
    1.  Functions of the Query Optimizer
    3m 56s
    Upon completion of this video, you will be able to describe the tasks of the query optimizer during SQL parsing. FREE ACCESS
  • Locked
    2.  Optimizer Key Concepts
    2m 35s
    Upon completion of this video, you will be able to describe the concepts of selectivity, cardinality, and cost. FREE ACCESS
  • Locked
    3.  Optimizer Statistics
    3m 49s
    Upon completion of this video, you will be able to describe statistics used by the optimizer. FREE ACCESS
  • Locked
    4.  Optimizer Parameters
    4m 30s
    Upon completion of this video, you will be able to list the database parameters that influence the behavior of the optimizer. FREE ACCESS
  • Locked
    5.  Adaptive and Dynamic Execution Plans
    4m 48s
    After completing this video, you will be able to describe adaptive and dynamic execution plans. FREE ACCESS
  • Locked
    6.  Cardinality Feedback
    4m 22s
    Upon completion of this video, you will be able to describe the cardinality feedback feature. FREE ACCESS
  • Locked
    7.  Optimizing SQL for Throughput
    2m 3s
    Upon completion of this video, you will be able to describe how manipulating the optimizer_mode parameter affects SQL operations. FREE ACCESS
  • Locked
    8.  Access Paths
    4m 44s
    After completing this video, you will be able to describe the ways in which data is retrieved from a database. FREE ACCESS
  • Locked
    9.  Index Operations
    4m 31s
    Upon completion of this video, you will be able to describe the most commonly used index access paths. FREE ACCESS
  • Locked
    10.  Join Operations
    3m 17s
    Upon completion of this video, you will be able to describe the concept of join operations. FREE ACCESS
  • Locked
    11.  Types of Join Operations
    3m 13s
    Upon completion of this video, you will be able to list the types of join operations used by the optimizer. FREE ACCESS
  • Locked
    12.  Join Performance
    3m 7s
    After completing this video, you will be able to describe the conditions under which each join operation works best. FREE ACCESS
  • Locked
    13.  Sort Operations and Performance
    3m 32s
    After completing this video, you will be able to describe the basics of sorting and briefly touch on how to improve sort performance. FREE ACCESS

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

Book Pro T-SQL 2022: Toward Speed, Scalability, and Standardization for SQL Server Developers, 2nd Edition
Audiobook Learning SQL: Generate, Manipulate, and Retrieve Data, 3rd Edition
Book Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)
Rating 4.6 of 255 users Rating 4.6 of 255 users (255)
Course Performance Tuning
Rating 4.5 of 32 users Rating 4.5 of 32 users (32)
Course Maintaining SQL Performance
Rating 4.7 of 7 users Rating 4.7 of 7 users (7)