Become a Materialized View SUPER HERO !

  Рет қаралды 10,150

SQL and Database explained!

SQL and Database explained!

Күн бұрын

Пікірлер: 24
@kokizzu
@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
@DatabaseDude Жыл бұрын
this is oracle mviews
@jirehla-ab1671
@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.
@johankuster1377
@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.
@robbybankston4238
@robbybankston4238 4 ай бұрын
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.
@aruljebin
@aruljebin Жыл бұрын
A quick recall.. thanks
@navarrodba
@navarrodba Жыл бұрын
Thanks for sharing. Super useful!!
@sitaramsahoo811
@sitaramsahoo811 Жыл бұрын
You are awesome! Thanks for sharing an important concept in a very short video yet more valuable. Good job!
@dpu11
@dpu11 Жыл бұрын
Awesome..thank you so much.Keep sharing such awesome knowledge.
@PatSloanx
@PatSloanx Жыл бұрын
Cool. Thanks for sharing!
@theboss9885
@theboss9885 Жыл бұрын
Wow... awesome trick. Loved it
@rembautimes8808
@rembautimes8808 11 ай бұрын
That was superhero material
@IanBond007
@IanBond007 Жыл бұрын
Outstanding! Thanks for the great explanation.
@promisinganuj
@promisinganuj Жыл бұрын
Great info, thanks for sharing
@SingleWingAcademy
@SingleWingAcademy 9 ай бұрын
it seems that ENABLE ON QUERY COMPUTATION is only available in oracledb and not postgres?
@DatabaseDude
@DatabaseDude 9 ай бұрын
I think that is correct
@vikram4755
@vikram4755 Жыл бұрын
amazing !
@kolansheen
@kolansheen Жыл бұрын
Great 👍
@juno7893
@juno7893 Жыл бұрын
🤣👏🏻👏🏻👏🏻
@yuriys4374
@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
@DatabaseDude Жыл бұрын
use dbms_mview.explain_mview to see if you need to add anything to the mview log
@yuriys4374
@yuriys4374 Жыл бұрын
@@DatabaseDude Thanks!!! It worked!
ROLLUP supercharges your GROUP BY queries!
2:21
SQL and Database explained!
Рет қаралды 1,8 М.
Simple steps to Faster Database Code
15:46
SQL and Database explained!
Рет қаралды 2,1 М.
كم بصير عمركم عام ٢٠٢٥😍 #shorts #hasanandnour
00:27
hasan and nour shorts
Рет қаралды 10 МЛН
This Game Is Wild...
00:19
MrBeast
Рет қаралды 174 МЛН
Из какого города смотришь? 😃
00:34
МЯТНАЯ ФАНТА
Рет қаралды 2,5 МЛН
1, 2, 3, 4, 5, 6, 7, 8, 9 🙈⚽️
00:46
Celine Dept
Рет қаралды 114 МЛН
Speeding up Queries by Pre-computation & Transformation
10:50
CodeOpinion
Рет қаралды 10 М.
My THREE rules for SQL TUNING
12:45
SQL and Database explained!
Рет қаралды 4,4 М.
The KEEP clause will KEEP your SQL queries SIMPLE!
7:06
SQL and Database explained!
Рет қаралды 4,3 М.
An intro to Materialized Views in ClickHouse
6:44
ClickHouse
Рет қаралды 7 М.
Materialized views in oracle - Part 1
19:03
Tech Coach
Рет қаралды 76 М.
Speeding up Database Constraints
6:59
SQL and Database explained!
Рет қаралды 1,6 М.
كم بصير عمركم عام ٢٠٢٥😍 #shorts #hasanandnour
00:27
hasan and nour shorts
Рет қаралды 10 МЛН