Sep 14, 2022 · Databases

Understanding SQL Query Execution Order: From FROM to LIMIT

The article explains the logical execution order of a SQL query—starting with FROM/JOIN, then WHERE, GROUP BY, HAVING, SELECT, DISTINCT, ORDER BY, and finally LIMIT—using diagrams, code snippets, and practical examples to illustrate each step.

Backend DevelopmentQuery Execution OrderSQL

0 likes · 6 min read

Understanding SQL Query Execution Order: From FROM to LIMIT

Qunar Tech Salon

Jul 9, 2019 · Databases

SQL Fundamentals and Query Optimization Techniques for PostgreSQL

This article introduces SQL fundamentals, explains DDL/DML/DCL categories, and provides practical PostgreSQL query optimization techniques—including index selection, condition rewriting, sub‑query removal, expression and partial indexes, DDL decomposition, CTE usage, and key configuration parameters—to help developers and DBAs improve performance and maintainability.

Database PerformancePostgreSQLSQL

0 likes · 12 min read

SQL Fundamentals and Query Optimization Techniques for PostgreSQL