Understanding optimizer hints in 19c
Ғылым және технология
Hints are easy to specify in your SQL statement, but that doesn't mean they are easy to understand, or easy to know when they are incorrect or inappropriate. But that just became a lot easier in 19c....
blog: connor-mcdonald.com
twitter: / connor_mc_d
Why the optimizer might ignore your hints: • Why did the optimizer ...
Subscribe for new tech videos every week
All other social media channels here: linktr.ee/connor
Are you serious? A free Oracle database forever ?!?!?!?! Hell yeah!!!
www.oracle.com/cloud/free
Music: Night Owl (Broke For Free),
Dyalla
#oracle #hints #optimizer
Пікірлер: 9
That's a nice 19c improvement, thanks for the demo !
Absolutely amazing stuff!! Thank you so much for this presentation
@DatabaseDude
4 жыл бұрын
Glad you enjoyed it!
This channel is a treasure. I used to learn such concepts by Hit and Try, but here is Connor providing everything on a platter. Thanks a ton!
@DatabaseDude
Жыл бұрын
Happy to help!
Hi Conor,Kindly post a detailed video of advanced queueing in plsql. Want to know the used cases and example as well.
@DatabaseDude
4 жыл бұрын
will put it on the list of things to do :-)
I did not think that the index-hint at 4:15 would work - I thought you had to supply the index name as well as the table name/alias for the hint to work. Can you omit it if there is just a single index on the table?
@DatabaseDude
4 жыл бұрын
you are basically giving the optimizer the flexibility to choose any existing index