Become a Materialized View SUPER HERO !

Подписаться 14 тыс.

Просмотров 8 тыс.

50% 1

Every time your materialized view gets stale and your applications can no longer rely on their accuracy, you get slower queries or very unhappy customers. But there is a way you can become a SUPER HERO DBA by using real time query computation!
Follow me!
blog: connor-mcdonald.com
twitter: / connor_mc_d
The Podcast!
podcasts.apple.com/au/podcast...
open.spotify.com/show/5dqVVft...
Subscribe for new tech videos every week
Other social media channels here: linktr.ee/connor
Music: The Wine, The Cars, Ah! Montmartre! - Late Night Feeler
#sql #database

Наука

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

12 янв 2023

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 22

@navarrodba Год назад

Thanks for sharing. Super useful!!

@johankuster1377 Год назад

Great! I need to have replay that one. This opens some new possibilities. I could even correct some suboptimal database design and/or add partitioning. Need some study and testing though.

@dpu11 Год назад

Awesome..thank you so much.Keep sharing such awesome knowledge.

@IanBond007 Год назад

Outstanding! Thanks for the great explanation.

@promisinganuj Год назад

Great info, thanks for sharing

@sitaramsahoo811 Год назад

You are awesome! Thanks for sharing an important concept in a very short video yet more valuable. Good job!

@PatSloanx Год назад

Cool. Thanks for sharing!

@aruljebin Год назад

A quick recall.. thanks

@theboss9885 Год назад

Wow... awesome trick. Loved it

@kolansheen Год назад

Great 👍

@kokizzu 8 месяцев назад

hmm.. what database is this? '__')? clickhouse materialized view refreshed on insert, so only delta applied, not sure about bigquery (every 3 minutes? and not sure how the cost/billing)

@DatabaseDude 8 месяцев назад

this is oracle mviews

@jirehla-ab1671 8 месяцев назад

Hi , i remember oravle offering free entperse edition of oracle 21c (non-commercial use only), but i cant find the same equivalent for 23c since the 23c develop edition haa 12gb ram limit.

@vikram4755 Год назад

amazing !

@SingleWingAcademy 4 месяца назад

it seems that ENABLE ON QUERY COMPUTATION is only available in oracledb and not postgres?

@DatabaseDude 3 месяца назад

I think that is correct

@rembautimes8808 6 месяцев назад

That was superhero material

@juno7893 Год назад

🤣👏🏻👏🏻👏🏻

@yuriys4374 Год назад

Hello. Cool. Everything is ok with INSERT. But how does it work with DELETE, UPDATE? After DELETE a row from a table select /*+ fresh_mv */ from my_mv query returns ORA-32358

@DatabaseDude Год назад

use dbms_mview.explain_mview to see if you need to add anything to the mview log

@yuriys4374 Год назад

@@DatabaseDude Thanks!!! It worked!