Done properly, creating an index requires a lot of validation effort to ensure you don't totally break your application. Are you doing all the things you are meant to do? In version 19c, the database will follow best practice and do this automatically.
blog: https://connor-mcdonald.com
twitter: / connor_mc_d
Subscribe for new tech videos every week
All other social media channels here: https://linktr.ee/connor
My current favorite Oracle stuff:
Favorite 12.2 feature: Almost all structural maintenance can be done online. No more outages.
https://docs.oracle.com/en/database/o...
Favorite 18c feature: Killing a runaway SQL without killing the entire session.
https://docs.oracle.com/en/database/o...
Favorite 19c feature: Handling JSON just got a lot easier!
https://docs.oracle.com/en/database/o...
Music: Night Owl (Broke For Free)
#oracle #19c #indexes
Watch video Best practice for creating indexes online without registration, duration hours minute second in high quality. This video was added by user SQL and Database explained! 23 May 2019, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,687 once and liked it 54 people.