Just checking, when you mentioned at the last portion gather stats... do you mean by gather stats using the hint or gather stats of the tables and indexes
Thank you Maria for explaining Explain Plan beautifully. Please help me with one doubt. At around 56 min of the video, example no. 3 of Join Type. i.) Employee table is having 107 rows. Department table is having 27 rows. Both tables having a small data set. ii.) There are indexes on tables as there is primary-foreign key relationship. My concern is why hasn't the optimizer gone for "Nested Loops" join method. Because we have indexes and small data set. Why has optimizer selected "Hash" join? Please help me understand. Thank you!
The best video I have ever seen on performance tuning. awesome explanation and the best way to engage attendees. Thanks Maria
Excellent. Covers all the basics of Explain Plan.
Documentation says there is more access paths than those 9 mentioned at 33:00. Those are clustered table access paths etc
Maria - I love you. This is gold !
Execution plan explained perfectly. Thank you Maria
Great knowledge, good voice,very explanative.
Great content and well explained!
You are awesome , Maria . Many thanks .. well done 👍
this is so excellent explanation. Where can I download the slide? Thanks!
How can one generate the tree? Is the SQL Monitor a separate tool? Is it a feature within SQL Developer?
hi, thank you so muh for sharing this issue, i hve a question, what's the meaning of INLIST ITERATOR?
excellent Maria ,,,,.....Please share awr analysis video
Can you please publish ASAP
understanding AWR & actions to take in Oracle 19c Also when to use sqlprofile/ash/addm interperting the sql section in AWR
Hi Gopi, we have a few AWR presentations available in our file library. www.odtug.com/tech-resources
Is the abominable name Toad or Pl-SQL Developer?
Nice overview. Surprised that crowd did not even know basics like "join methods"
Just checking, when you mentioned at the last portion gather stats... do you mean by gather stats using the hint or gather stats of the tables and indexes
tanks you very much
Thank you Maria for explaining Explain Plan beautifully. Please help me with one doubt. At around 56 min of the video, example no. 3 of Join Type.
i.) Employee table is having 107 rows. Department table is having 27 rows. Both tables having a small data set.
ii.) There are indexes on tables as there is primary-foreign key relationship.
My concern is why hasn't the optimizer gone for "Nested Loops" join method. Because we have indexes and small data set.
Why has optimizer selected "Hash" join?
Please help me understand.
Thank you!
Really good
Cloud disappeared...
Brilliant Explanation, I hope someday Maria Colgan wants to come to Latin America.