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 56s
-
2.Optimizer Key Concepts2m 35s
-
3.Optimizer Statistics3m 49s
-
4.Optimizer Parameters4m 30s
-
5.Adaptive and Dynamic Execution Plans4m 48s
-
6.Cardinality Feedback4m 22s
-
7.Optimizing SQL for Throughput2m 3s
-
8.Access Paths4m 44s
-
9.Index Operations4m 31s
-
10.Join Operations3m 17s
-
11.Types of Join Operations3m 13s
-
12.Join Performance3m 7s
-
13.Sort Operations and Performance3m 32s
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.
