Become a Materialized View SUPER HERO !
Vložit
- čas přidán 12. 01. 2023
- 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 - Věda a technologie
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.
Thanks for sharing. Super useful!!
You are awesome! Thanks for sharing an important concept in a very short video yet more valuable. Good job!
Awesome..thank you so much.Keep sharing such awesome knowledge.
Outstanding! Thanks for the great explanation.
Great info, thanks for sharing
Wow... awesome trick. Loved it
Cool. Thanks for sharing!
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)
this is oracle mviews
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.
That was superhero material
A quick recall.. thanks
amazing !
Great 👍
it seems that ENABLE ON QUERY COMPUTATION is only available in oracledb and not postgres?
I think that is correct
🤣👏🏻👏🏻👏🏻
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
use dbms_mview.explain_mview to see if you need to add anything to the mview log
@@DatabaseDude Thanks!!! It worked!