BestHub
Sign in
Tag

Query Tuning

1 views collected around this technical thread.

Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
May 10, 2025 · Databases

10 Powerful SQL Optimization Techniques to Boost Query Performance

This article presents ten practical SQL optimization techniques—including replacing DISTINCT with GROUP BY, using UNION ALL instead of OR, avoiding functions on indexed columns, leveraging EXISTS over IN, creating covering indexes, partitioning large tables, and more—each illustrated with before-and-after code examples to dramatically improve query speed and reduce server load.

DatabaseMySQLQuery Tuning
0 likes · 10 min read
10 Powerful SQL Optimization Techniques to Boost Query Performance
Architect
Architect
Nov 4, 2024 · Databases

SQL Refactoring Case Study: Optimizing Complex Queries in the JDL Routing System

This article examines how uncontrolled growth of SQL code leads to performance and maintainability issues, then demonstrates a step‑by‑step refactoring of a complex routing‑system query—formatting, layer decomposition, merging, condition push‑down, join optimization, and testing—to achieve clearer, faster, and more reliable database operations.

Database OptimizationQuery TuningSQL
0 likes · 14 min read
SQL Refactoring Case Study: Optimizing Complex Queries in the JDL Routing System
JD Tech Talk
JD Tech Talk
May 21, 2024 · Databases

SQL Refactoring Case Study for JDL Routing System: Reducing Complexity and Improving Performance

This article presents a detailed case study of refactoring a complex, performance‑critical SQL query used in a JDL routing system, demonstrating step‑by‑step formatting, hierarchical decomposition, and optimization techniques such as layer merging, predicate push‑down, join simplification, and index tuning to dramatically reduce execution time.

DatabaseQuery TuningSQL
0 likes · 19 min read
SQL Refactoring Case Study for JDL Routing System: Reducing Complexity and Improving Performance
Top Architect
Top Architect
Apr 25, 2024 · Databases

Comprehensive Guide to MySQL Index Optimization and EXPLAIN Plan Analysis

This article explains MySQL's architecture, how to view storage engines and variables, demonstrates creating various indexes, describes why SQL optimization is needed, details the EXPLAIN plan keywords and index types, and provides practical best‑practice tips for single‑ and multi‑table query performance improvements.

EXPLAINIndex OptimizationMySQL
0 likes · 35 min read
Comprehensive Guide to MySQL Index Optimization and EXPLAIN Plan Analysis
Sanyou's Java Diary
Sanyou's Java Diary
Apr 15, 2024 · Databases

30 Proven SQL Optimization Tips to Boost Query Performance

This article presents thirty practical SQL optimization techniques, ranging from avoiding SELECT * and using LIMIT 1 to proper indexing, join strategies, and query rewriting, each illustrated with code examples and clear explanations to help developers write faster, more efficient database queries.

Database OptimizationIndexingQuery Tuning
0 likes · 28 min read
30 Proven SQL Optimization Tips to Boost Query Performance
macrozheng
macrozheng
Mar 28, 2024 · Databases

Boost MySQL Performance: 8 Proven Query Optimization Techniques

This article explains eight common MySQL performance pitfalls—including inefficient LIMIT offsets, implicit type conversion, sub‑query updates, mixed sorting, EXISTS clauses, condition pushdown, early LIMIT, and intermediate result handling—and provides rewritten SQL examples that dramatically improve execution speed.

MySQLQuery TuningSQL Optimization
0 likes · 14 min read
Boost MySQL Performance: 8 Proven Query Optimization Techniques
Selected Java Interview Questions
Selected Java Interview Questions
Sep 4, 2023 · Databases

Common MySQL Query Performance Issues and Optimization Techniques

This article discusses common MySQL performance pitfalls such as inefficient LIMIT usage, implicit type conversion, subquery updates, mixed ordering, EXISTS clauses, condition pushdown, and intermediate result handling, and provides optimized SQL rewrites and best practices to dramatically improve query execution speed.

IndexesMySQLQuery Tuning
0 likes · 13 min read
Common MySQL Query Performance Issues and Optimization Techniques
IT Services Circle
IT Services Circle
Jul 9, 2023 · Databases

20 Practical Rules for MySQL Index Optimization

This article presents twenty essential principles for optimizing MySQL indexes, covering topics such as the limitations of leading wildcard LIKE queries, the advantages of IN over UNION, handling negative conditions, composite index ordering, range queries, covering indexes, prefix indexes, and common pitfalls to avoid for better query performance.

Index OptimizationMySQLQuery Tuning
0 likes · 15 min read
20 Practical Rules for MySQL Index Optimization
IT Architects Alliance
IT Architects Alliance
Apr 11, 2023 · Databases

MySQL Execution Process and Comprehensive Optimization Best Practices

This article explains MySQL's query execution flow and provides extensive best‑practice guidelines—including naming conventions, storage engine choices, primary‑key design, character set settings, query writing tips, indexing strategies, batch operations, and performance‑enhancing techniques—to help developers write efficient and maintainable SQL code.

IndexingMySQLQuery Tuning
0 likes · 24 min read
MySQL Execution Process and Comprehensive Optimization Best Practices
Top Architect
Top Architect
Mar 29, 2023 · Databases

MySQL Query Optimization and Index Tuning: From Subqueries to Joins and Composite Indexes

This article demonstrates MySQL query performance issues with large tables, shows how a subquery without indexes can take hours, and walks through step‑by‑step optimizations including adding single‑column indexes, converting to EXISTS and JOIN queries, creating composite indexes, covering indexes, and sorting improvements, achieving speedups of thousands of times.

IndexingMySQLQuery Tuning
0 likes · 12 min read
MySQL Query Optimization and Index Tuning: From Subqueries to Joins and Composite Indexes
Efficient Ops
Efficient Ops
Mar 22, 2023 · Databases

8 Common SQL Pitfalls and How to Optimize Them for Lightning‑Fast Queries

This article reveals frequent SQL mistakes—such as misuse of LIMIT, implicit type conversion, sub‑query updates, mixed ordering, EXISTS, condition push‑down, premature filtering, and intermediate result push‑down—and provides concrete rewrite techniques that dramatically improve MySQL query performance.

DatabaseIndexesMySQL
0 likes · 14 min read
8 Common SQL Pitfalls and How to Optimize Them for Lightning‑Fast Queries
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 15, 2023 · Databases

SQL Statement Optimization Practices for MySQL

This article explains how DBAs can improve MySQL query performance by applying logical and physical optimizations, analyzing table structures, indexes, and execution plans, and provides a step‑by‑step checklist for diagnosing and rewriting slow or poorly optimized SQL statements.

IndexingMySQLQuery Tuning
0 likes · 8 min read
SQL Statement Optimization Practices for MySQL
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 10, 2022 · Databases

How to Effectively Use Partition Tables in Multi-Table Joins to Improve Query Performance

This article examines various multi‑table join scenarios in MySQL, demonstrating when partition tables can accelerate queries and when they degrade performance, supported by concrete examples, execution times, and explain plans to guide proper partition key usage.

Database OptimizationJoin PerformanceMySQL
0 likes · 11 min read
How to Effectively Use Partition Tables in Multi-Table Joins to Improve Query Performance
macrozheng
macrozheng
Nov 23, 2021 · Databases

15 Essential SQL Optimization Tips to Boost Query Performance

This article presents fifteen practical SQL optimization techniques—including avoiding SELECT *, using UNION ALL, leveraging IN/EXISTS, batching inserts, applying LIMIT, controlling IN list size, incremental queries, efficient pagination, preferring JOINs, limiting join tables, managing indexes, choosing proper column types, improving GROUP BY, and using EXPLAIN—to help developers dramatically improve query speed and resource usage.

DatabaseIndexingMySQL
0 likes · 20 min read
15 Essential SQL Optimization Tips to Boost Query Performance
Java Architect Essentials
Java Architect Essentials
Nov 15, 2021 · Databases

MySQL Optimization: Concepts, Schema Design, Indexes, and Query Tuning

This article provides a comprehensive overview of MySQL fundamentals—including logical architecture, locks, transactions, and storage engines—and offers practical optimization strategies for schema design, data types, indexing, and query execution, supplemented with code examples and performance‑analysis tips.

Database OptimizationIndexesMySQL
0 likes · 14 min read
MySQL Optimization: Concepts, Schema Design, Indexes, and Query Tuning
Top Architect
Top Architect
Aug 29, 2021 · Databases

MySQL Query Optimization Techniques and Common Pitfalls

This article presents a comprehensive guide to improving MySQL query performance by addressing common issues such as inefficient LIMIT usage, implicit type conversion, sub‑query updates, mixed sorting, EXISTS clauses, condition push‑down, early range reduction, intermediate result push‑down, and demonstrates how using WITH can simplify complex statements.

IndexesMySQLQuery Tuning
0 likes · 13 min read
MySQL Query Optimization Techniques and Common Pitfalls
Top Architect
Top Architect
Jul 28, 2021 · Databases

MySQL Optimization Guide: Storage Engines, Data Types, Index Strategies, and Query Tuning

This article provides a comprehensive collection of MySQL optimization techniques—including storage engine characteristics, data type selection, index design, and query rewriting—targeted at teams without a dedicated DBA, using MySQL 5.5 and InnoDB as the reference platform.

Data TypesDatabase OptimizationIndexing
0 likes · 18 min read
MySQL Optimization Guide: Storage Engines, Data Types, Index Strategies, and Query Tuning
Python Programming Learning Circle
Python Programming Learning Circle
Jul 19, 2021 · Databases

52 SQL Statement Performance Optimization Strategies

This article provides a comprehensive collection of 52 practical tips for improving SQL query performance, covering index creation, query rewriting, data type selection, storage engine choices, and execution plan analysis to help developers write faster, more efficient database statements.

DatabaseIndexesQuery Tuning
0 likes · 16 min read
52 SQL Statement Performance Optimization Strategies
Code Ape Tech Column
Code Ape Tech Column
Sep 20, 2020 · Databases

20 Principles for MySQL Index Optimization

This article presents twenty practical rules for optimizing MySQL indexes—including when to use or avoid indexes, how to write queries that can leverage them, the importance of index selectivity, prefix indexes, covering indexes, and common pitfalls—to help developers write faster, more efficient SQL statements.

Index OptimizationMySQLQuery Tuning
0 likes · 16 min read
20 Principles for MySQL Index Optimization