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

Oracle Multitenant Architecture Is Here To Stay!
18 January, 2023

Oracle Multitenant Architecture is the only way to go in version 21c. Are you ready for it? With version 12c the traditional, non-CDB architecture was deprecated, and with version 20c this architecture was de-supported. This means going forward Multitenant is …

Using Oracle XE database? Don’t wait until you hit the space limit before moving off it
9 January, 2023

We recently helped a client migrate from Oracle Database XE to SE2. There was no choice – they had reached the XE 12GB data limit. Going to SE2 is effectively a downgrade because XE has all the EE features, so …

ORDS 22.x on Windows bug
25 November, 2022

We just hit a silly problem with ORDS 22.x. When deploying ORDS to Tomcat, you have to create a version of the ords.war file that has the location of the ORDS configuration directory embedded within it. You do this by …

Free Online Registration Required

The tutorial session you want to view requires your registering with us.

It’s fast and easy, and totally FREE.

And best of all, once you are registered, you’ll also have access to all the other 100’s of FREE Video Tutorials we offer!

 

×