BestHub
Sign in
Tagged articles

indexes

279 articles · Page 1 of 3
Dabaoshi
Dabaoshi
Jul 26, 2026 · Databases

Practical MySQL SQL Optimization: How to Locate and Rewrite Slow Queries

The article explains how to make MySQL do less work by reducing scanned rows, avoiding back‑and‑forth lookups with covering indexes, and minimizing sorting or temporary tables, while detailing common index pitfalls, deep pagination tricks, COUNT usage, ORDER BY/filesort handling, JOIN strategies, and step‑by‑step methods for finding and fixing slow SQL statements.

Covering IndexEXPLAINJOIN
0 likes · 17 min read
Practical MySQL SQL Optimization: How to Locate and Rewrite Slow Queries
Dabaoshi
Dabaoshi
Jul 21, 2026 · Databases

Understanding MySQL EXPLAIN Execution Plans from Scratch

This article walks through MySQL's EXPLAIN output column by column, explaining id, table, select_type, type rankings, possible_keys, key, key_len, ref, rows, filtered, and Extra, while demonstrating each concept with concrete SQL examples, JSON‑formatted plans, and SHOW WARNINGS insights.

EXPLAINJSON formatMySQL
0 likes · 20 min read
Understanding MySQL EXPLAIN Execution Plans from Scratch
Architect's Tech Stack
Architect's Tech Stack
Jul 16, 2026 · Databases

Still Using IN and NOT IN in SQL? Here’s Why You Should Think Twice

The article explains that IN is fine for small constant lists, but NOT IN can produce unexpected empty results when NULL values appear, while EXISTS (or NOT EXISTS) often better expresses existence checks; it also stresses the decisive role of proper indexing and using EXPLAIN to verify performance.

NOT INNULLOptimization
0 likes · 10 min read
Still Using IN and NOT IN in SQL? Here’s Why You Should Think Twice
Architect Chen
Architect Chen
Jun 10, 2026 · Databases

12 Essential MySQL Online Commands Every DBA Should Know

This guide lists the most frequently used MySQL commands for checking version, connections, process lists, killing queries, global status, configuration variables, lock waits, slow‑query settings, table sizes, index information, execution plans, and replication status, each with practical usage scenarios.

DBADatabase AdministrationMySQL
0 likes · 5 min read
12 Essential MySQL Online Commands Every DBA Should Know
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
May 25, 2026 · Databases

11 Golden Rules for SQL Performance Optimization

This article explains why inefficient SQL queries cause most database bottlenecks and presents eleven concrete rules—covering indexes, SELECT *, LIMIT, WHERE clause tuning, join strategies, execution‑plan analysis, subqueries, DISTINCT, ORDER BY/GROUP BY, UNION vs UNION ALL, and query decomposition with materialized views—to help developers systematically improve SQL execution speed on MySQL and Oracle.

MySQLOptimizationOracle
0 likes · 16 min read
11 Golden Rules for SQL Performance Optimization
Architect's Guide
Architect's Guide
May 20, 2026 · Databases

30 Essential SQL Query Optimization Techniques

This article presents thirty practical SQL optimization tips, covering index usage, avoiding full‑table scans caused by operators like !=, NULL checks, OR, LIKE, IN, functions, and expressions, as well as best practices for temporary tables, cursors, and transaction size to improve database performance.

Query OptimizationSQLdatabase
0 likes · 10 min read
30 Essential SQL Query Optimization Techniques
Architect's Guide
Architect's Guide
May 14, 2026 · Databases

8 SQL Pitfalls That Can Slow Your Queries 100‑Fold – How to Avoid Them

The article enumerates eight common MySQL query patterns—such as large‑offset LIMIT, implicit type conversion, sub‑query updates, mixed ordering, unnecessary EXISTS, poor condition push‑down, early range reduction, and inefficient intermediate result handling—and shows rewritten SQL that reduces execution time from seconds to milliseconds.

JOINMySQLPerformance
0 likes · 15 min read
8 SQL Pitfalls That Can Slow Your Queries 100‑Fold – How to Avoid Them
Top Architect
Top Architect
Jan 18, 2026 · Databases

Boost Your SQL Query Speed: Proven Optimization Techniques

This guide walks through the SQL query processing workflow, explains how parsing, optimization, and execution plans affect performance, and provides concrete techniques—such as selecting specific columns, avoiding DISTINCT, using proper indexes, preferring EXISTS over COUNT, limiting result sets, and replacing HAVING with WHERE—to dramatically speed up queries while keeping statements concise.

Query OptimizationSQLSQL Best Practices
0 likes · 8 min read
Boost Your SQL Query Speed: Proven Optimization Techniques
Ray's Galactic Tech
Ray's Galactic Tech
Jan 8, 2026 · Databases

Boost SQL Performance Without Rewriting Queries: Indexes, Partitioning, Caching

This guide presents a comprehensive, step‑by‑step roadmap for accelerating slow SQL queries without altering the original statements, covering index creation, database parameter tuning, table partitioning, caching layers, read‑write splitting, sharding, statistics updates, hardware choices, and middleware routing.

CachingPerformance OptimizationSQL
0 likes · 8 min read
Boost SQL Performance Without Rewriting Queries: Indexes, Partitioning, Caching
dbaplus Community
dbaplus Community
Dec 16, 2025 · Databases

83 Proven SQL Optimization Techniques to Supercharge Your Database

This comprehensive guide presents 83 practical SQL optimization scenarios—from avoiding SELECT * and replacing IN with EXISTS to leveraging materialized views, partitioning, and advanced indexing—each illustrated with real‑world use cases and exact code snippets to help developers dramatically improve query performance and reduce resource consumption.

Database OptimizationQuery OptimizationSQL
0 likes · 55 min read
83 Proven SQL Optimization Techniques to Supercharge Your Database
JD Cloud Developers
JD Cloud Developers
Dec 12, 2025 · Big Data

Apache Hudi Core Concepts: Timeline, Indexes, Table Types & Queries

This article explains Apache Hudi’s core architecture, detailing the timeline mechanism, file layout, indexing strategies, the two main table types (Copy‑On‑Write and Merge‑On‑Read), and various query modes such as snapshot, time‑travel, read‑optimized and incremental queries.

Apache HudiData LakeTable Types
0 likes · 9 min read
Apache Hudi Core Concepts: Timeline, Indexes, Table Types & Queries
dbaplus Community
dbaplus Community
Dec 7, 2025 · Databases

Postgres vs MySQL: Deep Dive into Indexes, Query Costs, and MVCC

An in‑depth comparison of PostgreSQL and MySQL examines how primary and secondary indexes are implemented, contrasts query execution costs, explores data type impacts, explains MVCC undo logs, and discusses process versus thread architectures, highlighting performance trade‑offs for each system.

MVCCMySQLPostgreSQL
0 likes · 13 min read
Postgres vs MySQL: Deep Dive into Indexes, Query Costs, and MVCC
Selected Java Interview Questions
Selected Java Interview Questions
Dec 5, 2025 · Databases

Unlock MySQL 8.0’s Hidden Optimization Tricks to Supercharge Your Queries

Discover eight powerful, lesser‑known MySQL 8.0 features—including window functions, descending indexes, generated columns, invisible indexes, hints, resource groups, LATERAL JOIN, and multi‑valued JSON indexes—that can dramatically improve query performance, simplify code, and give you an edge in interviews and production environments.

Generated ColumnsJSONLATERAL JOIN
0 likes · 12 min read
Unlock MySQL 8.0’s Hidden Optimization Tricks to Supercharge Your Queries
Top Architect
Top Architect
Dec 2, 2025 · Databases

30 Essential SQL Query Optimization Tips from a Senior Architect

This article compiles thirty practical SQL performance tips, covering index usage, avoiding full table scans, proper handling of NULLs, OR/IN clauses, functions, temporary tables, cursors, and transaction size, each illustrated with clear example queries and recommended rewrites.

Query OptimizationSQLindexes
0 likes · 12 min read
30 Essential SQL Query Optimization Tips from a Senior Architect
Architect's Tech Stack
Architect's Tech Stack
Nov 14, 2025 · Databases

8 MySQL Optimizations to Slash Query Times from Seconds to Milliseconds

This article presents eight practical MySQL performance‑tuning techniques—including smarter LIMIT usage, avoiding implicit type conversion, rewriting updates and deletes with JOIN, handling mixed ordering, replacing EXISTS with JOIN, pushing conditions down, early range reduction, and using WITH clauses—to transform slow queries into millisecond‑level executions.

MySQLQuery RewriteSQL optimization
0 likes · 14 min read
8 MySQL Optimizations to Slash Query Times from Seconds to Milliseconds
Architect's Guide
Architect's Guide
Nov 5, 2025 · Databases

25 Essential SQL Query Optimization Tips to Avoid Full Table Scans

This article presents a comprehensive set of SQL performance guidelines, covering index creation, avoiding costly operators, rewriting predicates, using proper joins, limiting temporary objects, and best practices for query design to prevent full table scans and improve overall database efficiency.

PerformanceQuery OptimizationSQL
0 likes · 9 min read
25 Essential SQL Query Optimization Tips to Avoid Full Table Scans
Code Mala Tang
Code Mala Tang
Sep 1, 2025 · Databases

Boost SQL Query Performance: Practical Tips and Code Examples

This article presents a collection of practical techniques—such as using SELECT TOP, avoiding DISTINCT, preferring IN over OR, indexing key columns, and leveraging stored procedures—to dramatically improve SQL query speed and reduce database load.

Query OptimizationSQLdatabase
0 likes · 10 min read
Boost SQL Query Performance: Practical Tips and Code Examples
dbaplus Community
dbaplus Community
Aug 14, 2025 · Databases

10 Common Reasons Your PostgreSQL Queries Are Slow—and How to Fix Them

Discover the ten most frequent causes of sluggish PostgreSQL queries—from missing or inefficient indexes and poor query design to lack of vacuuming, table bloat, wrong data types, excessive sequential scans, deadlocks, missing connection pooling, overused ORDER BY/DISTINCT, and misconfigured settings—and learn concrete steps to resolve each issue.

PerformancePostgreSQLQuery Optimization
0 likes · 6 min read
10 Common Reasons Your PostgreSQL Queries Are Slow—and How to Fix Them
Sanyou's Java Diary
Sanyou's Java Diary
Aug 14, 2025 · Databases

Deep Dive into MySQL InnoDB Tablespaces, Undo Logs, and Doublewrite Buffer

This article explores MySQL InnoDB's memory and on‑disk architecture, detailing tablespace types, table and row formats, primary key strategies, index structures, the doublewrite buffer, redo log, undo log, and temporary tablespaces, complete with diagrams and code examples for practical understanding.

Doublewrite BufferInnoDBMySQL
0 likes · 25 min read
Deep Dive into MySQL InnoDB Tablespaces, Undo Logs, and Doublewrite Buffer
php Courses
php Courses
Jul 22, 2025 · Databases

10 Must‑Know Advanced SQL Tricks to Boost Your Development Efficiency

This article presents ten essential advanced SQL techniques—including EXPLAIN, window functions, CTEs, bulk operations, index optimization, transactions, JSON handling, temporary tables, proper NULL handling, and recursive queries—to help developers write more efficient, maintainable, and powerful database code.

Advanced QueriesCTEDatabase Optimization
0 likes · 8 min read
10 Must‑Know Advanced SQL Tricks to Boost Your Development Efficiency
Java Tech Enthusiast
Java Tech Enthusiast
Jul 14, 2025 · Databases

13 Proven SQL Optimization Tricks to Supercharge Your Queries

This article presents a comprehensive set of practical SQL optimization techniques—including proper indexing, selective column retrieval, efficient joins, query planning, and database‑specific features—to dramatically improve query speed, reduce resource consumption, and enhance overall application performance.

JoinsPerformanceQuery Optimization
0 likes · 12 min read
13 Proven SQL Optimization Tricks to Supercharge Your Queries
Sohu Tech Products
Sohu Tech Products
Jun 11, 2025 · Databases

Unlocking MySQL InnoDB: Deep Dive into Tablespaces, Undo Logs, and Indexes

This article explains MySQL InnoDB's dual memory and on‑disk architecture, detailing the various tablespace types (system, file‑per‑table, general, undo, temporary), their internal structures (segments, extents, pages), configuration tips, and how tables, row formats, primary keys, auto‑increment lock modes, and B+Tree indexes are organized and managed.

InnoDBMySQLTablespaces
0 likes · 18 min read
Unlocking MySQL InnoDB: Deep Dive into Tablespaces, Undo Logs, and Indexes
Java Tech Enthusiast
Java Tech Enthusiast
May 23, 2025 · Databases

MySQL Indexes, ACID, Raft, and gRPC: Technical Interview Insights

This article combines a Meituan salary update with detailed explanations of MySQL indexing strategies, B‑tree variations, ACID transaction properties, isolation levels, caching, handling high‑traffic queries, the Raft consensus algorithm, and an overview of gRPC, providing comprehensive backend development knowledge for interview preparation.

ACIDBackendMySQL
0 likes · 17 min read
MySQL Indexes, ACID, Raft, and gRPC: Technical Interview Insights
Top Architecture Tech Stack
Top Architecture Tech Stack
May 10, 2025 · Databases

MySQL Query Optimization Guidelines and Best Practices

This article presents a comprehensive set of MySQL optimization techniques, covering the avoidance of SELECT *, proper use of specific fields, index-friendly query patterns, join strategies, handling of NULL and default values, efficient use of UNION, batch inserts, and numerous other performance‑enhancing tips for database developers.

MySQLSQL optimizationdatabase tuning
0 likes · 17 min read
MySQL Query Optimization Guidelines and Best Practices
Senior Tony
Senior Tony
Apr 24, 2025 · Databases

How to Effectively Monitor and Optimize Slow SQL in Real Projects

The article explains a systematic interview‑ready approach to handling slow SQL: collect queries via Druid, MySQL slow‑query log or cloud exporters, prioritize by total execution time, analyze EXPLAIN output (type, key, rows, filtered, extra), and apply index, FORCE INDEX, join‑order, or off‑loading techniques for optimization.

MySQLOptimizationPerformance
0 likes · 9 min read
How to Effectively Monitor and Optimize Slow SQL in Real Projects
Code Ape Tech Column
Code Ape Tech Column
Apr 10, 2025 · Databases

Comprehensive Guide to SQL Optimization Steps and Common Scenarios

This article explains why SQL statements become performance bottlenecks as data grows, outlines a systematic optimization workflow—including slow‑query identification, EXPLAIN analysis, profiling, and tracing—and discusses practical solutions for index usage, query rewriting, pagination, range queries, and large‑scale data handling in MySQL.

Database OptimizationEXPLAINMySQL
0 likes · 12 min read
Comprehensive Guide to SQL Optimization Steps and Common Scenarios
Java Architect Essentials
Java Architect Essentials
Apr 7, 2025 · Databases

Practical MySQL Query Optimizations: LIMIT, Implicit Conversion, Join Rewrite, Mixed Sorting, EXISTS, Predicate Push‑down, Early Row Limiting, and Intermediate Result Push‑down

This article presents a series of MySQL performance‑tuning techniques—including smarter LIMIT usage, avoiding implicit type conversion, rewriting joins, handling mixed ordering, replacing EXISTS with joins, pushing predicates into subqueries, early row limiting, and using WITH clauses—to dramatically reduce query execution time across common scenarios.

JOINMySQLPredicate Pushdown
0 likes · 13 min read
Practical MySQL Query Optimizations: LIMIT, Implicit Conversion, Join Rewrite, Mixed Sorting, EXISTS, Predicate Push‑down, Early Row Limiting, and Intermediate Result Push‑down
Java Tech Enthusiast
Java Tech Enthusiast
Mar 23, 2025 · Databases

MySQL Query Optimization Techniques: LIMIT, Implicit Conversion, Joins and More

The article shows how common MySQL performance pitfalls—such as large LIMIT offsets, implicit type conversions, sub‑query‑based updates or deletes, mixed ORDER BY, EXISTS clauses, and misplaced predicates—can be rewritten into index‑friendly forms using filters, joins, early limits, UNION ALL, and CTEs to achieve execution times that drop from seconds to milliseconds.

JOINLIMITMySQL
0 likes · 14 min read
MySQL Query Optimization Techniques: LIMIT, Implicit Conversion, Joins and More
dbaplus Community
dbaplus Community
Mar 20, 2025 · Databases

15 Essential Tips for Designing Robust Database Tables

This guide covers practical best‑practice tips for database table design, including clear naming conventions, appropriate field types and lengths, primary‑key strategies, index usage, storage‑engine choices, NOT NULL handling, foreign‑key considerations, charset and collation settings, and handling of large fields.

Field Typesdatabase designindexes
0 likes · 17 min read
15 Essential Tips for Designing Robust Database Tables
Raymond Ops
Raymond Ops
Feb 20, 2025 · Databases

Master MySQL Slow Query Optimization: EXPLAIN Tips & Practical SQL Tuning

This guide walks through identifying slow MySQL queries using EXPLAIN, explains each output field, and presents practical optimization techniques—including proper index usage, pagination tricks, join improvements, and ORDER/GROUP BY tuning—to dramatically boost query performance.

EXPLAINMySQLSQL optimization
0 likes · 8 min read
Master MySQL Slow Query Optimization: EXPLAIN Tips & Practical SQL Tuning
IT Services Circle
IT Services Circle
Feb 2, 2025 · Databases

Performance Comparison of MySQL COUNT Queries on InnoDB and MyISAM

This article experimentally compares the performance of various MySQL COUNT queries on an InnoDB table with one million rows, explains the underlying execution plans using EXPLAIN, analyzes primary‑key versus secondary‑index behavior, and contrasts InnoDB’s fast count implementation.

COUNTEXPLAINInnoDB
0 likes · 9 min read
Performance Comparison of MySQL COUNT Queries on InnoDB and MyISAM
Liangxu Linux
Liangxu Linux
Jan 16, 2025 · Databases

Inside MySQL: How Buffer Pools, Indexes, and Logs Power Modern Databases

This article explains MySQL’s internal architecture, covering how data pages, B+‑tree and hash indexes, the Buffer Pool, Adaptive Hash Index, Change Buffer, Undo/Redo logs, the InnoDB storage engine, and the server layer work together to provide fast, reliable CRUD operations and support replication.

Buffer PoolInnoDBLogs
0 likes · 14 min read
Inside MySQL: How Buffer Pools, Indexes, and Logs Power Modern Databases
Java Architecture Stack
Java Architecture Stack
Dec 23, 2024 · Databases

10 Real-World MySQL Subquery Optimizations to Boost Performance

This article explains why MySQL subqueries can hurt performance, outlines common pitfalls such as temporary tables, index loss, and optimizer complexity, and presents ten concrete examples that replace subqueries with IN, EXISTS, JOIN, indexes, temporary tables, window functions, and LIMIT to achieve faster, more maintainable queries.

JOINMySQLSQL Performance
0 likes · 10 min read
10 Real-World MySQL Subquery Optimizations to Boost Performance
Top Architecture Tech Stack
Top Architecture Tech Stack
Dec 5, 2024 · Databases

Advanced MySQL Query Optimization Techniques: LIMIT, Implicit Conversion, Join Updates, Mixed Sorting, EXISTS, Predicate Pushdown, Early Range Reduction, and CTEs

This article explains common MySQL performance pitfalls such as large‑offset LIMIT queries, implicit type conversion, sub‑query updates, mixed sorting, inefficient EXISTS clauses, predicate push‑down limitations, and demonstrates how rewriting with proper indexes, JOINs, early range reduction, and WITH (CTE) statements can reduce execution time from seconds to milliseconds.

CTEMySQLPredicate Pushdown
0 likes · 12 min read
Advanced MySQL Query Optimization Techniques: LIMIT, Implicit Conversion, Join Updates, Mixed Sorting, EXISTS, Predicate Pushdown, Early Range Reduction, and CTEs
Su San Talks Tech
Su San Talks Tech
Nov 26, 2024 · Databases

15 Common MySQL Pitfalls and How to Avoid Them

This article outlines fifteen frequent MySQL mistakes—from missing WHERE clauses and absent indexes to improper data types, deep pagination, SQL injection risks, and inadequate backups—providing clear examples and practical solutions to improve query performance, data integrity, and overall database reliability.

Database OptimizationMySQLSQL
0 likes · 15 min read
15 Common MySQL Pitfalls and How to Avoid Them
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Oct 18, 2024 · Databases

Master MySQL Performance: 20 Essential SQL Optimization Techniques

This article presents a comprehensive guide for Java engineers on MySQL query optimization, covering index usage, avoiding SELECT *, proper JOINs, efficient WHERE clauses, LIMIT, EXISTS vs IN, function indexes, connection pooling, batch processing, data types, execution plan analysis, materialized views, and regular performance monitoring, all illustrated with practical code examples.

MySQLSQL optimizationdatabase
0 likes · 19 min read
Master MySQL Performance: 20 Essential SQL Optimization Techniques
Architect's Tech Stack
Architect's Tech Stack
Oct 15, 2024 · Databases

MySQL Query Optimization: LIMIT, Implicit Conversion, Join Rewrite, Mixed Sorting, EXISTS, Predicate Pushdown, Early Limiting, and Intermediate Result Pushdown

This article presents practical MySQL performance tuning methods, covering LIMIT pagination, implicit type conversion pitfalls, rewriting joins for updates/deletes, mixed-order sorting, replacing EXISTS with joins, predicate pushdown, early result limiting, and intermediate result pushdown, each illustrated with SQL examples and execution plan analyses.

MySQLPredicate PushdownSQL optimization
0 likes · 13 min read
MySQL Query Optimization: LIMIT, Implicit Conversion, Join Rewrite, Mixed Sorting, EXISTS, Predicate Pushdown, Early Limiting, and Intermediate Result Pushdown
Big Data Technology & Architecture
Big Data Technology & Architecture
Sep 18, 2024 · Databases

Doris Performance Optimization: OLAP Query, Indexes, Vectorized Execution, and High‑Concurrency Point Queries

This article explains how Apache Doris achieves high‑concurrency OLAP and point‑query performance through MPP architecture, columnar storage, partition‑bucket pruning, various indexes, materialized views, vectorized execution, runtime filters, short‑circuit planning, and prepared‑statement caching.

DorisHigh ConcurrencyOLAP
0 likes · 12 min read
Doris Performance Optimization: OLAP Query, Indexes, Vectorized Execution, and High‑Concurrency Point Queries
IT Services Circle
IT Services Circle
Sep 10, 2024 · Databases

Understanding MySQL Indexes: Types, Structures, and Optimization Techniques

This article provides a comprehensive overview of MySQL indexing, covering index classifications, B+Tree and Hash structures, primary and secondary (clustered and non‑clustered) indexes, covering index push‑down, index merge, covering indexes, cost‑based index selection, and common pitfalls that cause index inefficiency.

MySQLPerformanceSQL
0 likes · 27 min read
Understanding MySQL Indexes: Types, Structures, and Optimization Techniques
Top Architect
Top Architect
Jul 24, 2024 · Databases

Top 20 SQL Optimization Techniques for Better Query Performance

This article presents twenty practical SQL optimization techniques—including index usage, selective column queries, avoiding functions in WHERE clauses, replacing subqueries with joins, limiting result sets, using EXISTS, batch inserts, covering indexes, proper data types, pagination, and transaction management—to significantly improve query performance and database efficiency.

Best PracticesDatabase OptimizationSQL
0 likes · 11 min read
Top 20 SQL Optimization Techniques for Better Query Performance
Selected Java Interview Questions
Selected Java Interview Questions
Jul 16, 2024 · Databases

SQL Query Optimization Techniques

This article explains how to speed up SQL queries while keeping statements concise, covering the query processing workflow, optimization goals, and practical tips such as selecting specific columns, avoiding DISTINCT, using proper indexes, preferring EXISTS over COUNT, limiting result sets, favoring WHERE over HAVING, and replacing correlated subqueries with joins.

Query OptimizationSQLdatabase
0 likes · 9 min read
SQL Query Optimization Techniques
Top Architect
Top Architect
Jul 10, 2024 · Databases

Understanding MySQL Index Structures, Execution Plans, Transactions, and MVCC

This article provides a comprehensive overview of MySQL internals, covering index data structures such as B‑tree and B+‑tree, the differences between MyISAM and InnoDB indexes, SQL execution plan analysis, transaction isolation levels, lock mechanisms, MVCC implementation, and the InnoDB buffer‑pool caching process.

Buffer PoolMVCCexecution plan
0 likes · 19 min read
Understanding MySQL Index Structures, Execution Plans, Transactions, and MVCC
Top Architect
Top Architect
Jun 16, 2024 · Databases

20 Essential SQL Optimization Techniques for Better Query Performance

This article presents twenty practical SQL optimization techniques—including index usage, selective column queries, avoiding functions in WHERE clauses, replacing subqueries with joins, limiting result sets, using prepared statements, proper data types, and transaction handling—to improve query performance and overall database efficiency.

Database OptimizationQueriesSQL
0 likes · 11 min read
20 Essential SQL Optimization Techniques for Better Query Performance
Python Programming Learning Circle
Python Programming Learning Circle
May 17, 2024 · Databases

SQL Optimization Tips and Best Practices

This article presents a comprehensive collection of MySQL performance guidelines, covering query writing, index usage, join strategies, data types, batch operations, and execution plan analysis to help developers write faster and more reliable SQL statements.

Best PracticesOptimizationPerformance
0 likes · 19 min read
SQL Optimization Tips and Best Practices
ITPUB
ITPUB
May 5, 2024 · Databases

What GitLab’s 34k‑Line Postgres Schema Reveals About Scalable Database Design

This article examines GitLab’s extensive PostgreSQL schema, explaining why the project uses a pure‑SQL structure file, how primary‑key choices, internal versus external IDs, naming conventions, timestamps, text types, partitioning, GIN indexes, JSONB columns, foreign‑key strategies and other data‑type decisions impact performance, maintainability, and scalability.

JSONBPartitioningPostgreSQL
0 likes · 25 min read
What GitLab’s 34k‑Line Postgres Schema Reveals About Scalable Database Design
Liangxu Linux
Liangxu Linux
Apr 14, 2024 · Databases

Boost MySQL Performance: 8 Proven SQL Optimization Techniques

This article presents eight practical MySQL optimization methods—including smarter LIMIT usage, avoiding implicit type conversion, rewriting joins, handling mixed ordering, replacing EXISTS with joins, pushing down conditions, pre‑filtering data, and using WITH clauses—to dramatically reduce query execution time.

MySQLQuery RewriteSQL optimization
0 likes · 13 min read
Boost MySQL Performance: 8 Proven SQL Optimization Techniques
Java Architect Essentials
Java Architect Essentials
Apr 3, 2024 · Databases

MySQL Query Optimization Techniques: LIMIT, Implicit Conversion, Join Updates, Mixed Sorting, EXISTS, Condition Pushdown, Early Limiting, and Intermediate Result Pushdown

This article presents a series of MySQL performance‑enhancing techniques—including smarter LIMIT usage, avoiding implicit type conversion, rewriting UPDATE/DELETE with JOINs, mixed‑order sorting tricks, replacing EXISTS with JOINs, condition push‑down, early result limiting, and intermediate result push‑down—to dramatically reduce query execution time.

MySQLdatabaseindexes
0 likes · 13 min read
MySQL Query Optimization Techniques: LIMIT, Implicit Conversion, Join Updates, Mixed Sorting, EXISTS, Condition Pushdown, Early Limiting, and Intermediate Result Pushdown
Su San Talks Tech
Su San Talks Tech
Mar 16, 2024 · Databases

Master MySQL Performance: Deep Dive into Indexes and Explain Plans

This comprehensive guide explains MySQL's architecture, the importance of SQL optimization, detailed index types and creation methods, how to interpret EXPLAIN output, and practical techniques to improve query performance while avoiding common pitfalls.

Explain PlanMySQLSQL optimization
0 likes · 35 min read
Master MySQL Performance: Deep Dive into Indexes and Explain Plans
ITPUB
ITPUB
Jan 8, 2024 · Databases

How I Cut an 8‑Second SQL Query to 0.7 Seconds: Step‑by‑Step Optimization

This article walks through a real‑world case of a slow MySQL query that took 8 seconds, explains how the original use of EXISTS and NOT EXISTS caused performance bottlenecks, and details two successive rewrites—first using JOIN + GROUP BY, then replacing NOT EXISTS with NOT IN—bringing execution time down to 0.7 seconds while highlighting key indexing and testing lessons.

MySQLQuery OptimizationSQL
0 likes · 7 min read
How I Cut an 8‑Second SQL Query to 0.7 Seconds: Step‑by‑Step Optimization
JD Retail Technology
JD Retail Technology
Dec 12, 2023 · Databases

Common SQL Optimization Techniques for MySQL

This article reviews MySQL's execution process and presents a comprehensive list of practical SQL optimization strategies—including indexing, query rewriting, avoiding costly operators, using batch operations, and leveraging EXPLAIN—to improve database performance and maintainability.

MySQLSQL optimizationdatabase tuning
0 likes · 14 min read
Common SQL Optimization Techniques for MySQL
dbaplus Community
dbaplus Community
Dec 5, 2023 · Databases

How I Cut an 8‑Second Slow Query to 0.7 Seconds with Two Optimizations

The article walks through a real‑world case of a slow MySQL query that took 8 seconds, explains why simple indexing wasn't enough, and demonstrates two successive rewrites using JOIN‑GROUP BY and NOT IN that reduced execution time to 0.7 seconds while detailing the EXPLAIN analysis.

EXPLAINMySQLQuery Optimization
0 likes · 6 min read
How I Cut an 8‑Second Slow Query to 0.7 Seconds with Two Optimizations
ITPUB
ITPUB
Nov 25, 2023 · Databases

8 Common SQL Pitfalls and How to Optimize Them for Faster Queries

This article examines eight frequent MySQL performance problems—including misuse of LIMIT, implicit type conversion, sub‑query updates, mixed ordering, EXISTS, condition push‑down, early limiting, and intermediate result push‑down—and provides concrete rewrite techniques and example code that dramatically reduce execution time.

MySQLOptimizationSQL
0 likes · 13 min read
8 Common SQL Pitfalls and How to Optimize Them for Faster Queries
Architect
Architect
Nov 7, 2023 · Databases

MySQL Architecture, Indexes, and SQL Optimization Guide

This article explains MySQL's basic architecture, demonstrates how to view and set storage engines, and provides comprehensive guidance on SQL optimization methods, index types, creation, usage, and performance analysis using EXPLAIN, helping readers improve query efficiency and avoid common pitfalls.

EXPLAINMySQLSQL optimization
0 likes · 35 min read
MySQL Architecture, Indexes, and SQL Optimization Guide
Selected Java Interview Questions
Selected Java Interview Questions
Nov 3, 2023 · Databases

Comprehensive Guide to MySQL Architecture, SQL Optimization Techniques, and Explain Plan Analysis

This article provides an in‑depth overview of MySQL’s core architecture, storage engines, index types, and practical SQL optimization methods, followed by detailed explanations of the EXPLAIN plan keywords and numerous real‑world examples to help developers improve query performance and avoid common indexing pitfalls.

Explain PlanSQL optimizationdatabase performance
0 likes · 34 min read
Comprehensive Guide to MySQL Architecture, SQL Optimization Techniques, and Explain Plan Analysis
Liangxu Linux
Liangxu Linux
Sep 10, 2023 · Databases

Master MySQL Query Optimization: Architecture, Caching, and Index Strategies

This article explains MySQL's logical architecture, query execution flow, caching mechanisms, and detailed index design techniques, providing practical tips and examples so developers can understand the underlying principles and apply effective performance optimizations in real‑world applications.

MySQLQuery OptimizationSQL
0 likes · 38 min read
Master MySQL Query Optimization: Architecture, Caching, and Index Strategies
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.

Query TuningSQL optimizationdatabase performance
0 likes · 13 min read
Common MySQL Query Performance Issues and Optimization Techniques
Su San Talks Tech
Su San Talks Tech
Sep 4, 2023 · Databases

Master MySQL Interview Essentials: 43 Key Topics Explained

This comprehensive guide consolidates 43 essential MySQL interview topics—from normalization, storage engines, and indexing to transaction handling, logging, replication, and performance tuning—providing clear explanations, code examples, and diagrams to help candidates quickly master the core concepts.

Database InterviewMySQLReplication
0 likes · 37 min read
Master MySQL Interview Essentials: 43 Key Topics Explained
macrozheng
macrozheng
Sep 3, 2023 · Databases

Why a Single UPDATE Can Crash Your MySQL Database and How to Prevent It

This article explains how an UPDATE without indexed WHERE conditions can trigger full‑table next‑key locks in InnoDB, causing business downtime, and provides practical safeguards such as enabling sql_safe_updates and using FORCE INDEX to ensure safe execution.

InnoDBMySQLUpdate
0 likes · 8 min read
Why a Single UPDATE Can Crash Your MySQL Database and How to Prevent It
macrozheng
macrozheng
Aug 31, 2023 · Databases

15 Essential Tips for Designing Robust Database Tables

This guide walks backend developers through fifteen practical best‑practice tips covering table and column naming, data types, field lengths, primary keys, storage engines, null constraints, foreign keys, indexes, time and monetary fields, character sets, collations, and handling large columns to reduce maintenance costs and avoid common pitfalls.

MySQLSQLindexes
0 likes · 20 min read
15 Essential Tips for Designing Robust Database Tables
ITPUB
ITPUB
Aug 15, 2023 · Databases

Master MySQL Performance: Practical SQL Optimization and Indexing Techniques

This comprehensive guide explains MySQL’s architecture, index fundamentals, the EXPLAIN plan keywords, step‑by‑step index creation and deletion commands, and numerous real‑world optimization examples, helping developers dramatically improve query execution speed while avoiding common pitfalls.

Explain PlanMySQLdatabase performance
0 likes · 35 min read
Master MySQL Performance: Practical SQL Optimization and Indexing Techniques
Top Architect
Top Architect
Aug 15, 2023 · Databases

Why Avoid NULL Columns in MySQL: Performance and Indexing Considerations

The article examines the drawbacks of using NULL columns in MySQL, explaining how they increase storage space, complicate indexing and query optimization, and can cause performance issues, while providing examples and best practices for defining NOT NULL constraints and handling data correctly.

MySQLNULLPerformance
0 likes · 9 min read
Why Avoid NULL Columns in MySQL: Performance and Indexing Considerations
php Courses
php Courses
Jul 3, 2023 · Databases

MySQL Queries That Cannot Use Indexes

Certain MySQL queries, such as those using functions, leading wildcards in LIKE, OR operators, inequality comparisons, or NULL checks, prevent the database engine from utilizing indexes, leading to slower performance, and should be rewritten for optimal query efficiency.

MySQLPerformanceSQL
0 likes · 3 min read
MySQL Queries That Cannot Use Indexes
php Courses
php Courses
Jul 1, 2023 · Databases

MySQL Queries That Cannot Use Indexes

This article explains five common MySQL query patterns—using functions, leading wildcards with LIKE, OR operators, inequality comparisons, and NULL checks—that prevent the database engine from utilizing indexes, and provides example SQL statements illustrating each case.

Database OptimizationMySQLSQL
0 likes · 3 min read
MySQL Queries That Cannot Use Indexes
Top Architect
Top Architect
Jun 1, 2023 · Databases

Comprehensive Guide to MySQL Indexes, Types, and Query Optimization

This article explains the definition, data structures, advantages, disadvantages, and appropriate usage scenarios of MySQL indexes, details primary, unique, single‑column and composite index types, analyzes common performance bottlenecks with EXPLAIN, demonstrates index creation, invalidation cases, query and join optimizations, and shows how to configure and use the slow‑query log.

EXPLAINMySQLQuery Optimization
0 likes · 19 min read
Comprehensive Guide to MySQL Indexes, Types, and Query Optimization
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.

MySQLOptimizationPerformance
0 likes · 14 min read
8 Common SQL Pitfalls and How to Optimize Them for Lightning‑Fast Queries
Shepherd Advanced Notes
Shepherd Advanced Notes
Mar 22, 2023 · Databases

Mastering MySQL Indexes: Advanced Concepts and Practical Tips

This article provides a comprehensive deep‑dive into MySQL indexing, covering the definition, pros and cons, differences between clustered and non‑clustered indexes, InnoDB vs MyISAM implementations, B+Tree structure, capacity calculations, adaptive hash indexes, index pushdown optimization, and how to interpret EXPLAIN output to verify index usage.

Adaptive Hash IndexB+ TreeIndex Pushdown
0 likes · 18 min read
Mastering MySQL Indexes: Advanced Concepts and Practical Tips
Open Source Linux
Open Source Linux
Feb 9, 2023 · Databases

Master MySQL Optimization: Indexes, Explain Plans, and Performance Tips

This comprehensive guide explores MySQL architecture, index types, query execution plans, and practical optimization techniques, offering detailed examples of creating, modifying, and analyzing indexes, avoiding common pitfalls, and improving query performance through proper use of EXPLAIN, composite indexes, and query rewriting.

Explain PlanMySQLSQL optimization
0 likes · 36 min read
Master MySQL Optimization: Indexes, Explain Plans, and Performance Tips
dbaplus Community
dbaplus Community
Jan 4, 2023 · Databases

Mastering MySQL Indexes: Costs, Pitfalls, and Best Practices

This article walks through practical MySQL index usage, illustrating space and time costs, back‑table overhead, covering indexes and index condition pushdown, common scenarios where indexes fail, and concrete best‑practice guidelines, all demonstrated with a 5‑million‑row InnoDB table and real SQL examples.

Database OptimizationInnoDBMySQL
0 likes · 15 min read
Mastering MySQL Indexes: Costs, Pitfalls, and Best Practices
Laravel Tech Community
Laravel Tech Community
Jan 2, 2023 · Databases

Advanced MySQL Query Optimization Techniques: LIMIT, Implicit Conversion, Join Rewrite, and More

This article presents a series of practical MySQL performance‑tuning methods—including smarter LIMIT usage, handling implicit type conversion, rewriting UPDATE/DELETE with JOIN, mixed‑order optimization, EXISTS replacement, condition push‑down, early result filtering, and CTE usage—to dramatically reduce query execution time across common scenarios.

CTEJOINLIMIT
0 likes · 13 min read
Advanced MySQL Query Optimization Techniques: LIMIT, Implicit Conversion, Join Rewrite, and More
IT Architects Alliance
IT Architects Alliance
Oct 12, 2022 · Databases

Master MySQL Execution Order: 8 Proven Techniques to Supercharge Query Performance

This article explains MySQL's execution order and presents eight practical optimizations—including smarter LIMIT usage, implicit conversion handling, join‑based updates, mixed sorting, EXISTS rewriting, condition push‑down, early range reduction, and intermediate result push‑down—each illustrated with SQL examples and performance measurements.

MySQLSQL optimizationdatabase
0 likes · 14 min read
Master MySQL Execution Order: 8 Proven Techniques to Supercharge Query Performance