Become a Materialized View SUPER HERO !

preview_player
Показать описание
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!

The Podcast!

Subscribe for new tech videos every week

Music: The Wine, The Cars, Ah! Montmartre! - Late Night Feeler

#sql #database
  1. SQL and Database explained!
  2. oracle
  3. oracle database
  4. asktom
  5. office hours
Рекомендации по теме
Become a Materialized 0:07:05

Become a Materialized View SUPER HERO !

Materialized View in 0:16:40

Materialized View in SQL | Faster SQL Queries using Materialized Views

Count Millions of 0:12:09

Count Millions of Rows Fast with Materialized Views: Databases for Developers: Performance #6

Materialized Views VS. 0:04:17

Materialized Views VS. Views - What's The Difference?

How To Speed 0:17:11

How To Speed Up Your Queries With Materialized Views

Streaming Tables and 0:03:54

Streaming Tables and Materialized Views on Databricks SQL

Materialized Views | 0:03:58

Materialized Views | SQL

The simple way 0:07:59

The simple way to refresh materialized views

Postgres Hacking with 0:44:37

Postgres Hacking with Andrey, Kirk, and Nikolay: include ANALYZE steps to all dumps - part 1/2

Noria: Fast Materialized 1:09:49

Noria: Fast Materialized Views for Fast Websites (Malte Schwarzkopf)

Speeding up Queries 0:10:50

Speeding up Queries by Pre-computation & Transformation

Optimize Tinybird Endpoints 0:05:27

Optimize Tinybird Endpoints with Materialized Views

Materialized Views and 0:22:46

Materialized Views and Projections Under the Hood

Create Materialized View 0:02:34

Create Materialized View Demo

Faster Django Queries 0:15:10

Faster Django Queries With Materialized Views

Amazon Redshift Automated 0:08:22

Amazon Redshift Automated Materialized Views | Amazon Web Services

An intro to 0:06:44

An intro to Materialized Views in ClickHouse

STANDARD vs. MATERIALIZED 0:10:15

STANDARD vs. MATERIALIZED views in SQL | BigQuery

Materialized Views in 0:16:57

Materialized Views in Azure Data

Indexed Views (Materialized 0:11:55

Indexed Views (Materialized Views) in SQL Server and Performance Considerations

039 Materialized Views 0:04:07

039 Materialized Views with ON DEMAND option

Postgres Views and 0:43:45

Postgres Views and Materialized Views with Examples

Indexed Views (Materialized 0:07:13

Indexed Views (Materialized Views) in SQL Server with Clustering | SQL Performance Considerations

Materialized Views and 0:52:08

Materialized Views and More SQL Stuff

Комментарии
Автор

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)

kokizzu
Автор

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.

johankuster
Автор

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

sitaramsahoo
Автор

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

dpu
Автор

Good explanation but it would be great if you could show the query output and performance while explaining it. Screenshot sometimes are not good enough

JayShinde-hlds
Автор

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.

robbybankston
Автор

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

SingleWingAcademy
Автор

Outstanding! Thanks for the great explanation.

IanBond
Автор

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

yuriys