How to determine the Join Order in an execution plan in Oracle
Maria Colgan (SQLMaria)
View ChannelAbout
Welcome to my YouTube channel, where I share information on Oracle Database features and functionality to demonstrates how you can revolutionize Data Management by adopting Transformational Technologies! This YouTube channel is used in conjunction with my blog https://sqlmaria.com, which has all of the code examples used in the videos in an easy to cut-and-paste format. All content Copyright © 2021 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Latest Posts
No results found. Try different keywords.
Video Description
The join order in an execution plan is the order in which the optimizer decides to join tables together in a multi-table SQL statement. Determining the join order in an execution plan and knowing if it's optimal and how to correct it if it's not is a tricky proposition for most of us. This video explains the simple set of rules the optimizer uses to determine the join order and provides two simple approaches to help you find the join order for both straightforward and complex plans. I also discuss why you don't always get an optimal plan and how to fix it. TOC What is the join order? 0:15 Optimizer rules for selecting the join order 1:00 How to determine the join order using depth-first search 2:30 How to find the join order from the outline of the plan 3:46 What causes suboptimal join orders, and how you can correct them 5:44
No Recommendations Found
No products were found for the selected channel.