Become a Materialized View SUPER HERO !
ฝัง
- เผยแพร่เมื่อ 3 ต.ค. 2024
- 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
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.
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.
Thanks for sharing. Super useful!!
That was superhero material
Cool. Thanks for sharing!
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.
Outstanding! Thanks for the great explanation.
Wow... awesome trick. Loved it
A quick recall.. thanks
Great info, 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.
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!