Understanding optimizer hints in 19c

Поделиться
HTML-код
  • Опубликовано: 13 дек 2024

Комментарии • 9

  • @MOHITSHARMA-bc6cy
    @MOHITSHARMA-bc6cy Год назад +1

    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!

  • @venivediwow
    @venivediwow 4 года назад +3

    Absolutely amazing stuff!! Thank you so much for this presentation

  • @OutdoorsHappiness
    @OutdoorsHappiness 4 года назад +1

    That's a nice 19c improvement, thanks for the demo !

  • @chrissigsegv
    @chrissigsegv 4 года назад

    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
      @DatabaseDude  4 года назад

      you are basically giving the optimizer the flexibility to choose any existing index

  • @ashismohanty1958
    @ashismohanty1958 4 года назад

    Hi Conor,Kindly post a detailed video of advanced queueing in plsql. Want to know the used cases and example as well.

    • @DatabaseDude
      @DatabaseDude  4 года назад

      will put it on the list of things to do :-)