Back

What is the order of the steps in a Oracle Execution Plan?

  • Posted by elimark
  • Date February 3, 2022

The starting point is to determine the join order: the sequence in which the various row sources are joined. This may not be the sequence in which the tables are first addressed, or the sequence in which they appear in the plan.

author avatar
elimark

You may also like

3 Processes That Make Data Guard Work
25 October, 2023

Have you ever wondered what is happening behind the scene in a Data Guard environment? How and who is sending the logs from the primary to standby? What process is applying the changes on the standby side? How is it …

How to Create an Oracle Standby Database in 5 Steps
18 September, 2023

Setting up Oracle Data Guard for a database might be daunting for many DBAs. The process involves creating a standby database from the primary database and it seems complicated and convoluted, but is it really? When we come across something …

Chrome Extension To Automatically Format Your APEX and PLSQL Code
31 March, 2023

The built in code editor in APEX is missing a very useful thing: the ability to automatically format the code. If you are using a tool like VSCode, Toad or SQL Developer to write your SQL or PL/SQL code, everything …