Materialization

DataFunTalk

Mar 16, 2024 · Big Data

Performance Optimization Practices for KwaiBI Big Data Analysis Platform

This article introduces KwaiBI, the internal data analysis product of Kuaishou, outlines its five major functional areas, details the performance challenges of large‑scale analytics, and presents a comprehensive set of optimization techniques—including cache warming, query rewriting, materialized acceleration, and the Bleem lake‑house engine—along with future directions and a brief Q&A.

KwaiBIMaterializationQuery Optimization

0 likes · 15 min read

Performance Optimization Practices for KwaiBI Big Data Analysis Platform

Aikesheng Open Source Community

Sep 21, 2020 · Databases

Understanding Semi‑join Materialization in MySQL Subquery Optimization

This article explains how MySQL transforms eligible subqueries into semi‑joins, describes the four semi‑join strategies, and details the Semi‑join Materialization approach—including Materialization‑scan and Materialization‑lookup—while showing how to identify the chosen strategy via EXPLAIN output.

Database PerformanceMaterializationMySQL

0 likes · 9 min read

Understanding Semi‑join Materialization in MySQL Subquery Optimization

Aikesheng Open Source Community

Jun 28, 2020 · Databases

MySQL Subquery Optimization Strategies and Rewriting DELETE with JOIN

This article explains why a DELETE statement with a sub‑query can cause a full‑table scan in MySQL, describes the optimizer's semijoin, materialization and exists strategies for different sub‑query types, and shows how to rewrite the statement using a JOIN for better performance.

DELETEJoinMaterialization

0 likes · 9 min read

MySQL Subquery Optimization Strategies and Rewriting DELETE with JOIN