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 parsingdescribe the concepts of selectivity, cardinality and costdescribe statistics used by the optimizerlist the database parameters which influence the behaviour of the optimizerdescribe adaptive and dynamic execution plansdescribe the cardinality feedback featuredescribe how manipulating the optimizer_mode parameter affects SQL operations
-
describe the ways in which data is retrieved from the databasedescribe the most commonly used index access pathsdescribe the concept of join operationslist the types of join operations used by the optimizerdescribe the conditions under which each join operation works bestdescribe 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 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
Channel
Wintellect SQL Server
Likes 1