Become a Materialized View SUPER HERO !

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-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
Music: The Wine, The Cars, Ah! Montmartre! - Late Night Feeler
#sql #database

[@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.

[@kokizzu]

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]

this is oracle mviews

[@jirehla-ab1671]

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.

[@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!

[@robbybankston4238]

I would suggest mentioning early on the view video which dialect of SQL or platform you are on as the details vary between Oracle, SQL Server, MySQL, PostgreSQL, etc.

[@rembautimes8808]

That was superhero material

[@sitaramsahoo811]

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

[@aruljebin]

A quick recall.. thanks

[@dpu11]

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

[@navarrodba]

Thanks for sharing. Super useful!!

[@theboss9885]

Wow... awesome trick. Loved it

[@PatSloanx]

Cool. Thanks for sharing!

[@juno7893]

🤣👏🏻👏🏻👏🏻

[@promisinganuj]

Great info, thanks for sharing

[@vikram4755]

amazing !

[@SingleWingAcademy]

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

[@DatabaseDude]

I think that is correct

[@kolansheen]

Great 👍

[@IanBond007]

Outstanding! Thanks for the great explanation.