Read Oracle SQL Execution Plan | DBMS XPLAN

[@ziadfawzi]

Thank you.

[@dbagenesis]

Welcome!

[@aturan-fo1qt]

Thanks, great explanation 👍

[@dbagenesis]

Glad it was helpful!

[@abdultaheriqbal1117]

Thanks Sir providing such videos .....

[@prasadreddysunkari]

Awesome and valuable information sir.. million thanks

[@dbagenesis]

Thank you!

[@dhavalpandya4162]

Hello sir, in real time I have seen SQL query of more than 800 lines and when we see the plan it looks very complicated, there are n number of terms they use and which confuses us.
Can you please elaborate execution plan for a really long query if possible ?

[@shahbaz6865]

3:16
You don't need to write clear screen. Just write clear scr.

[@dbagenesis]

Thanks, new learning for me ;)

[@vinny_vlogs4262]

But from where the statistics are coming for auto Trace option?

[@dbagenesis]

Base tables

[@luzaumbk]

As base tables you should think as Data Dictionary tables that keeps information about tables, columns and indexes.

[@dharshanramakrishna2237]

How do you tune a query without hints? In real world to tune complex queries we are forced to use hints

[@dbagenesis]

Hints let you make decisions usually made by the optimizer. As an application designer, you might know information about your data that the optimizer does not know. Hints provide a mechanism to instruct the optimizer to choose a certain query execution plan based on the specific criteria.
If you want to tune query without hint then you have to remove unnecessary large-table full-table scans, Cache small-table full-table scans, Verify optimal index usage, Materialize your aggregations and summaries for static tables