Oracle SQL Tuning Indexes
Improve your SQL Tuning skills by gaining more knowledge about indexes and their particularities
3.75 (14 reviews)
104
students
4 hours
content
Mar 2019
last update
$19.99
regular price
What you will learn
Understand the role of the index for the database, its advantages and disadvantages
How to create effective indexes without overloading the database with useless indexes
Understand the statistics that influence the Optimizer in choosing an index for execution plan
Understand the architecture and functioning of the BTREE index
Understand the most commonly used index access operations
How to use specialized indexes (Function base Index, Compressed Index, Composite Index, etc.) to improve query performance
How to identify the causes that lead the Optimizer not to use an index and what needs to be done to make it use
Related Topics
2138356
udemy ID
1/9/2019
course created date
11/23/2019
course indexed date
Bot
course submited by