Oracle Optimizer Access Methods

[@marcinbadtke]

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

[@oscar-3592]

Hi Maria, thank you for your videos, very interesting. Can you recommend a book on sql tuning?

[@TheNobody04]

Wow, thank you so much for this video!

[@syedmohsin677]

Awesome!!! Thanks Maria.

[@venkatv2973]

we are looking for tunning tools , like AWR analysis , proactive tuning and reactive tuning videos

[@satishguddhati9609]

Thanks for sharing

[@rakesh-w7m]

Awesome to explain

[@ziadfawzi]

Thank you.

[@venkatv2973]

can you please make videos on tuning?

[@SQLMaria]

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!

[@pnaryavuz7264]

do u have more examples to share with us?