Loading
Topic
materialized views
5 posts about materialized views by 5 contributors.
Know materialized views? Share what you know with developers who are learning it.
+ Follow materialized viewsBe the first to follow this
- Articles
- 5
- Contributors
- 5
Everything about materialized views
- Article · Databricks
One SQL statement for a self-refreshing reporting table in Databricks
Create a Databricks SQL materialized view that refreshes daily, documents its columns, and calculates reporting metrics in a single statement.
- Article · Databases & DBA
ClickHouse Materialized Views: How to Keep Dashboard Aggregates Up to Date
Learn how to use ClickHouse incremental materialized views and SummingMergeTree tables to maintain accurate, efficient dashboard aggregates as new data arrives.
- Article · SQL Server
SQL Materialized Views for Complex Aggregates in SQL Server | Practical Guide with Real-World Patterns
Boost SQL Server performance with materialized views! This guide provides a step-by-step approach to creating indexed views for complex aggregates, improving query speed.
- Article · Power BI
Performance Tuning a Tableau Dashboard with SQL Optimization
This article reveals how SQL optimization dramatically improves performance. Learn to identify bottlenecks, implement indexing, pre-aggregate data with materialized views, optimize joins, and use incremental data loads. Transform sluggish dashboards into lightning-fast visualizations by focusing on SQL first!
- Article · SQL Server
SQL Query Execution Understanding Process and Performance
Understanding the SQL query execution order—from FROM and JOIN to WHERE, GROUP BY, HAVING, SELECT, ORDER BY, and LIMIT/OFFSET—is crucial for optimizing queries. Key techniques include indexing, optimizing joins, early filtering, avoiding SELECT *, and using subqueries, CTEs, caching, and materialized views to enhance performance.
