Тёмный

Does the PARALLEL hint disable indexes? 

SQL and Database explained!
Подписаться 15 тыс.
Просмотров 3,6 тыс.
50% 1
ВидеоПоделитьсяСкачатьДобавить в

If your query is currently using an index, you might be in for a surprise when you add the PARALLEL hint to make it faster.
Follow me!
blog: connor-mcdonal...
twitter: / connor_mc_d
The Podcast!
podcasts.apple...
open.spotify.c...
Subscribe for new tech videos every week
Other social media channels here: linktr.ee/connor
A free Oracle database forever ?! Oh yes indeed!
www.oracle.com...
Music: Night Owl (Broke For Free), Kevin Mcleod (incomptech), Dyalla
#oracle #parallel #performance

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

 

29 сен 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 10   
@elmorautube
@elmorautube 2 года назад
Always scratching my head on this situation, glad to have it finally explained so nicely ;)
@roderickdunn2517
@roderickdunn2517 8 месяцев назад
Thanks for this explanation, it was helpful! Question - I have a simple SELECT * query similar to yours but when I add index_ffs and parallel_index hints the plan shows that both are unused, and it simply uses an INDEX RANGE SCAN instead (no parallism). Any idea why that would be? For context, the table is huge (6 billion rows), and the WHERE condition filters out all except ~100 million rows.
@roderickdunn2517
@roderickdunn2517 8 месяцев назад
Figured it out. Its because index_ffs only works when no ROW access is required - but in my case the SELECT * requires row access. TY
@eddiehapson1730
@eddiehapson1730 Год назад
Nice
@steveandreassend8620
@steveandreassend8620 Год назад
So which one was the fastest? Love the KIWI acronym
@studio48nl
@studio48nl 2 года назад
@6:08 so true!
@angshumanchatterjee6729
@angshumanchatterjee6729 2 года назад
Neat explanation 👌🏻
@DatabaseDude
@DatabaseDude 2 года назад
Thank you 🙂
@sshfromhere
@sshfromhere 2 года назад
Great explanation ! Thank you )
@DatabaseDude
@DatabaseDude 2 года назад
You are welcome!
Далее
The FASTEST way to unload data to CSV
12:37
The FASTEST way to unload data to CSV
Просмотров 4,6 тыс.
Using DBMS_XPLAN.DISPLAY_CURSOR to examine execution plans
12:33
Using DBMS_XPLAN.DISPLAY_CURSOR to examine execution plans
Просмотров 35 тыс.
Почему?
00:22
Почему?
Просмотров 177 тыс.
Отжимания по методике Чарльза Бронсона #отжимания #спорт #тренировки #ктоэто #академияброкколи
00:20
Отжимания по методике Чарльза Бронсона #отжимания #спорт #тренировки #ктоэто #академияброкколи
Просмотров 355 тыс.
FATAL CHASE 😳 😳
00:19
FATAL CHASE 😳 😳
Просмотров 1,4 млн
Qalpoq - Amakivachcha (hajviy ko'rsatuv)
41:44
Qalpoq - Amakivachcha (hajviy ko'rsatuv)
Просмотров 312 тыс.
Harnessing the power of Oracle Database optimizer hints | CloudWorld 2022
32:57
Harnessing the power of Oracle Database optimizer hints | CloudWorld 2022
Просмотров 4,5 тыс.
New Parallel DML Hint - Quirks and Features
10:32
New Parallel DML Hint - Quirks and Features
Просмотров 3 тыс.
Why Isn't My Query Using an Index? Databases for Developers: Performance #5
11:52
Why Isn't My Query Using an Index? Databases for Developers: Performance #5
Просмотров 12 тыс.
Top 5 Query Hints A Practical Approach
15:05
Top 5 Query Hints A Practical Approach
Просмотров 1,5 тыс.
Oracle Parallel Execution Plans Deep Dive
44:23
Oracle Parallel Execution Plans Deep Dive
Просмотров 7 тыс.
Understanding optimizer hints in 19c
8:45
Understanding optimizer hints in 19c
Просмотров 3,5 тыс.
How to read a Parallel Execution Plan in Oracle
12:01
How to read a Parallel Execution Plan in Oracle
Просмотров 8 тыс.
How to Read an Execution Plan: Databases for Developers: Performance #1
9:34
How to Read an Execution Plan: Databases for Developers: Performance #1
Просмотров 64 тыс.
Why Rebuild Indexes? | #dailyDBA 20
30:50
Why Rebuild Indexes? | #dailyDBA 20
Просмотров 25 тыс.
How Does the Phyiscal Location of Rows Affect Indexes?: Finding All the Red Sweets Part 2
9:25
How Does the Phyiscal Location of Rows Affect Indexes?: Finding All the Red Sweets Part 2
Просмотров 7 тыс.
Почему?
00:22
Почему?
Просмотров 177 тыс.