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
History
Students
Price
Rating & Reviews
Related Topics
2138356
udemy ID
09/01/2019
course created date
23/11/2019
course indexed date
Bot
course submited by