Tagged articles

ExecutionPlan

2 articles · Page 1 of 1

Dec 27, 2023 · Databases

Analyzing the Execution Process and Cost of Three‑Table JOIN in MySQL

This article examines how MySQL executes a three‑table JOIN using nested‑loop algorithms, demonstrates the scanning row counts and cost calculations with concrete examples, and explains why the optimizer’s estimated fan‑out can differ from actual runtime statistics.

CostAnalysisExecutionPlanIndexNestedLoop

0 likes · 10 min read

Analyzing the Execution Process and Cost of Three‑Table JOIN in MySQL

政采云技术

Jul 12, 2022 · Big Data

Understanding Spark SQL Physical Execution Plans and Optimization Techniques

This article explains Spark SQL's physical execution plan, detailing each operator, how to interpret the plan, and practical optimization tips for data warehouse developers to improve SQL performance and resource utilization.

DataWarehouseExecutionPlanPerformanceOptimization

0 likes · 10 min read

Understanding Spark SQL Physical Execution Plans and Optimization Techniques