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/
@zafar915611 ай бұрын
Excellent topic , please add more videos with more examples ..
@DatabaseStar11 ай бұрын
Sure, will do!
@budmonk281911 ай бұрын
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.
@DatabaseStar10 ай бұрын
Oh yes good point!
@Muhammadilyas-nk4ox11 ай бұрын
Greate topic and lecture thanks a lot
@DatabaseStar11 ай бұрын
You're welcome!
@inesh-study7 ай бұрын
great explanation, thank you very much. can we have the github repo for db
@DatabaseStar7 ай бұрын
Thanks! The repo should be here: github.com/bbrumm/databasestar