Become a Materialized View SUPER HERO !

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

[@navarrodba]

Thanks for sharing. Super useful!!

[@sitaramsahoo811]

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

[@dpu11]

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

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

[@PatSloanx]

Cool. Thanks for sharing!

[@aruljebin]

A quick recall.. thanks

[@IanBond007]

Outstanding! Thanks for the great explanation.

[@theboss9885]

Wow... awesome trick. Loved it

[@rembautimes8808]

That was superhero material

[@promisinganuj]

Great info, thanks for sharing

[@SingleWingAcademy]

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

[@DatabaseDude]

I think that is correct

[@vikram4755]

amazing !

[@kolansheen]

Great 👍

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