Tuning Problem SQL Statements
Oracle 12c
| Intermediate
- 13 videos | 48m 26s
- Includes Assessment
- Earns a Badge
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
-
1. Functions of the Query Optimizer3m 56sUpon completion of this video, you will be able to describe the tasks of the query optimizer during SQL parsing. FREE ACCESS
-
2. Optimizer Key Concepts2m 35sUpon completion of this video, you will be able to describe the concepts of selectivity, cardinality, and cost. FREE ACCESS
-
3. Optimizer Statistics3m 49sUpon completion of this video, you will be able to describe statistics used by the optimizer. FREE ACCESS
-
4. Optimizer Parameters4m 30sUpon completion of this video, you will be able to list the database parameters that influence the behavior of the optimizer. FREE ACCESS
-
5. Adaptive and Dynamic Execution Plans4m 48sAfter completing this video, you will be able to describe adaptive and dynamic execution plans. FREE ACCESS
-
6. Cardinality Feedback4m 22sUpon completion of this video, you will be able to describe the cardinality feedback feature. FREE ACCESS
-
7. Optimizing SQL for Throughput2m 3sUpon completion of this video, you will be able to describe how manipulating the optimizer_mode parameter affects SQL operations. FREE ACCESS
-
8. Access Paths4m 44sAfter completing this video, you will be able to describe the ways in which data is retrieved from a database. FREE ACCESS
-
9. Index Operations4m 31sUpon completion of this video, you will be able to describe the most commonly used index access paths. FREE ACCESS
-
10. Join Operations3m 17sUpon completion of this video, you will be able to describe the concept of join operations. FREE ACCESS
-
11. Types of Join Operations3m 13sUpon completion of this video, you will be able to list the types of join operations used by the optimizer. FREE ACCESS
-
12. Join Performance3m 7sAfter completing this video, you will be able to describe the conditions under which each join operation works best. FREE ACCESS
-
13. Sort Operations and Performance3m 32sAfter 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.
