The best video I have ever seen on performance tuning. awesome explanation and the best way to engage attendees. Thanks Maria
@MohammedImran-ij1tb
3 жыл бұрын
Excellent. Covers all the basics of Explain Plan.
@vivekghag1642
6 жыл бұрын
Execution plan explained perfectly. Thank you Maria
@budmonk2819
3 жыл бұрын
Maria - I love you. This is gold !
@spinthma
4 жыл бұрын
Great content and well explained!
@massefromla2554
5 жыл бұрын
You are awesome , Maria . Many thanks .. well done 👍
@marcellodias2377
3 жыл бұрын
Great knowledge, good voice,very explanative.
@user-fi9rw4vx2b
Жыл бұрын
Documentation says there is more access paths than those 9 mentioned at 33:00. Those are clustered table access paths etc
@harshadocp
5 жыл бұрын
Nice overview. Surprised that crowd did not even know basics like "join methods"
@kevinzhang8974
4 жыл бұрын
this is so excellent explanation. Where can I download the slide? Thanks!
@girishkumar-ic8pp
6 жыл бұрын
excellent Maria ,,,,.....Please share awr analysis video
@saidtel1978
2 жыл бұрын
tanks you very much
@nenenartey4266
2 жыл бұрын
Is the abominable name Toad or Pl-SQL Developer?
@dmy0
4 жыл бұрын
How can one generate the tree? Is the SQL Monitor a separate tool? Is it a feature within SQL Developer?
@taythiamjoo7723
6 жыл бұрын
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
@camposgutierrezm
4 жыл бұрын
hi, thank you so muh for sharing this issue, i hve a question, what's the meaning of INLIST ITERATOR?
@gopikanagal2141
3 жыл бұрын
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
@Odtug
3 жыл бұрын
Hi Gopi, we have a few AWR presentations available in our file library. www.odtug.com/tech-resources
@ramchinthakayala2092
5 жыл бұрын
Really good
@bahamas1600
6 жыл бұрын
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!
@googdriveforme4115
4 жыл бұрын
Cloud disappeared...
@anibalgarcia2786
2 жыл бұрын
Brilliant Explanation, I hope someday Maria Colgan wants to come to Latin America.
Пікірлер: 22