Oracle Optimizer Access Methods
Vložit
- čas přidán 23. 07. 2024
- The Access Method - or access path - in an Oracle execution plan shows how data will be accessed from each table (or index) in your query. The Optimizer selects the Access
from the nine different options available to it. This video describes the nine different Access Methods and explains when the Optimizer will choose each one. At the end of the video, you have an opportunity to play the role of the Optimizer as we work through several sample statements and decide what would be the best Access Method for each statement.
TOC
What are Oracle Optimizer Access Methods? 0:14
How many Access Methods does the Oracle Optimizer have? 0:30
What is a Full Table Scan? 0:54
What is a Table Access By ROWID? 2:19
What is Index Unique Scan? 3:14
What is an Index Range Scan? 3:40
What is an Index Skip Scan? 4:17
What is a Full Index Scan? 5:10
What is a Fast Full Index Scan? 5:59
What is an Index Join? 6:35
What is a Bitmap Index access? 7:10
How to find the access method in an execution plan? 8:02 - Věda a technologie
Thank you
00:00 Intro
00:55 Full Table Scan
02:20 Table Access by ROWID
03:15 Index Unique Scan
03:42 Index Range Scan
04:21 Index Skip Scan
05:11 Full Index Scan
05:59 Fast Full Index Scan
06:36 Index Join
07:11 Bitmap Indexes
08:03 Execution Plan Analysis
08:30 Examples
Wow, thank you so much for this video!
Awesome!!! Thanks Maria.
Awesome to explain
Thanks for sharing
Thank you.
Hi Maria, thank you for your videos, very interesting. Can you recommend a book on sql tuning?
we are looking for tunning tools , like AWR analysis , proactive tuning and reactive tuning videos
do u have more examples to share with us?
can you please make videos on tuning?
Hi Venkat, thanks for watching and for the suggestion. Once I'm done with the Explain the Explain plan topic, I do plan to move on to a series on SQL tuning. So please stay tuned!