Тёмный

Understanding optimizer hints in 19c 

SQL and Database explained!
Подписаться 14 тыс.
Просмотров 3,3 тыс.
50% 1

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

Наука

Опубликовано:

 

10 авг 2020

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 9   
@OutdoorsHappiness
@OutdoorsHappiness 3 года назад
That's a nice 19c improvement, thanks for the demo !
@MOHITSHARMA-bc6cy
@MOHITSHARMA-bc6cy Год назад
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
@DatabaseDude Год назад
Happy to help!
@venivediwow
@venivediwow 3 года назад
Absolutely amazing stuff!! Thank you so much for this presentation
@DatabaseDude
@DatabaseDude 3 года назад
Glad you enjoyed it!
@ashismohanty1958
@ashismohanty1958 3 года назад
Hi Conor,Kindly post a detailed video of advanced queueing in plsql. Want to know the used cases and example as well.
@DatabaseDude
@DatabaseDude 3 года назад
will put it on the list of things to do :-)
@chrissigsegv
@chrissigsegv 3 года назад
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 3 года назад
you are basically giving the optimizer the flexibility to choose any existing index
Далее
Does the PARALLEL hint disable indexes?
7:43
Просмотров 3,4 тыс.
Самоприкорм с сестрой 😂
00:19
Просмотров 281 тыс.
New Parallel DML Hint - Quirks and Features
10:32
Просмотров 2,8 тыс.
Top 5 Query Hints A Practical Approach
15:05
Просмотров 1,2 тыс.
The optimizer HINT that rules them all!
4:39
Просмотров 2,3 тыс.
Map your JSON into PL/SQL easily with 23ai
3:14
Internal queries KILLING my database!
7:22
Просмотров 1,5 тыс.
Неразрушаемый смартфон
1:00
Просмотров 1,9 млн