How to See Where Your Oracle SQL Query is Slow

[@DatabaseStar]

Want to understand what each of the steps in the Execution Plan is doing? Get my Oracle Execution Plan Guide here: www.databasestar.com/execution-plan-guide/

[@zafar9156]

Excellent topic , please add more videos with more examples ..

[@DatabaseStar]

Sure, will do!

[@budmonk2819]

The reason it wasn't using the added indexes was because the Primary Key is already indexed by default and of course - the optimizer felt that the full table scan is cheaper.

[@DatabaseStar]

Oh yes good point!

[@Muhammadilyas-nk4ox]

Greate topic and lecture thanks a lot

[@DatabaseStar]

You're welcome!

[@inesh-study]

great explanation, thank you very much. can we have the github repo for db

[@DatabaseStar]

Thanks! The repo should be here: github.com/bbrumm/databasestar