From the course: Designing Highly Scalable and Highly Available SQL Databases

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Materialized views for transactional queries

Materialized views for transactional queries

From the course: Designing Highly Scalable and Highly Available SQL Databases

Start my 1-month free trial

Materialized views for transactional queries

“

- [Instructor] Materialized views are an important technique for improving scalability and reducing latency in query time. Basically, the idea behind a materialized view is that we're going to execute a query, then we're going to take the results and save them out somewhere and we're just going to keep them available for future needs. So the idea here is that, rather than running a query and going to find the data and look up indexes every time that query gets executed, let's just do it once or once in a while and keep the results and then use those results to answer the query so we don't have to go back and do all of that work from scratch. So, it's a form of caching and it comes with all the risks of caching and we'll talk about that a little bit more, some things you need to consider. But definitely think of it as a form of caching that trades space for time. So we're going to use more storage space to keep the…

Contents