Interpreting execution plans in Oracle Part 1

Подписаться 2,4 тыс.

Просмотров 4 тыс.

50% 1

Here I tried to break up an execution plan to show how to read a plan for a SQL in Oracle database. Considering this a very critical subject, this is the first installation of this series, I will go and publish few more, maybe 2 more videos on execution plans.
Keep learning and watching! ... \,,/

Опубликовано:

8 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 4

@mukeshsinghrawat7211 2 года назад

Hi Prashant, eagerly waiting for next two videos on this topic.

@mohammedmoizuddin7628 2 года назад

Hi prashant, at 22:33 while explaining Index full scan you said Index is exact replica of the table. Can you pls explain what exactly it means.

@thefatdba 2 года назад

Hi Mohamad, That statement was for an access path 'Index Full Scan' where you do not read only the required entries from the Index, but scans the entire Index and its tree like structure from top to bottom. This is almost same like doing a full scan on a table (with slight improvements only), and thats how the Index Scan and Table scans becomes almost same in case kf a INDEX FULL SCAN. Hope I am able to clarify! Have a great day Prashant 'The FatDBA'

@mohammedmoizuddin7628 2 года назад

@@thefatdba Thanks for explaining and giving time.