BestHub
Sign in
Tagged articles
272 articles
Page 2 of 3
Open Source Linux
Open Source Linux
Apr 1, 2022 · Databases

Master MySQL Performance: Deep Dive into Indexes, Explain Plans, and Optimization Techniques

This comprehensive guide explores MySQL's architecture, explains how indexes work, details the use of EXPLAIN to analyze query execution, and provides practical optimization strategies—including index creation, avoiding common pitfalls, and improving single- and multi-table queries—to dramatically boost database performance.

indexesmysqlperformance tuning
0 likes · 33 min read
Master MySQL Performance: Deep Dive into Indexes, Explain Plans, and Optimization Techniques
Liangxu Linux
Liangxu Linux
Mar 28, 2022 · Databases

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

This comprehensive guide explains MySQL's architecture, storage engines, and the critical role of indexes, walks through the SQL parsing process, details how to read and interpret EXPLAIN output, and provides practical optimization examples for single‑table and multi‑table queries.

Database Performanceexplainindexes
0 likes · 38 min read
Master MySQL Performance: Indexes, Explain Plans, and Optimization Tips
Laravel Tech Community
Laravel Tech Community
Feb 13, 2022 · Databases

Understanding NULL Values and Their Impact on Indexes in MySQL

This article explains how MySQL treats NULL values, the behavior of IS NULL, IS NOT NULL, the spaceship operator, IFNULL, and demonstrates with practical examples how NULL affects indexing, query performance, aggregation functions, and sorting, while offering recommendations for schema design.

NULLSQLindexes
0 likes · 12 min read
Understanding NULL Values and Their Impact on Indexes in MySQL
dbaplus Community
dbaplus Community
Jan 16, 2022 · Databases

Essential MySQL Query Optimization Tips to Avoid Full Table Scans

This guide compiles practical MySQL performance techniques—including proper indexing, avoiding costly operators, rewriting OR conditions, using EXISTS, limiting SELECT *, managing temporary tables, configuring threads, choosing storage engines, and optimizing data types—to dramatically reduce full‑table scans and improve query speed.

Database designSQL Performanceindexes
0 likes · 21 min read
Essential MySQL Query Optimization Tips to Avoid Full Table Scans
Java Backend Technology
Java Backend Technology
Dec 28, 2021 · Databases

Unlock MySQL JSON: Design, Index, and Query Strategies for Dynamic Data

This article explains how MySQL's JSON data type bridges relational and non‑relational storage, shows practical table designs for user login and profiling, demonstrates querying with JSON functions and operators, and covers function and multi‑valued indexes to efficiently retrieve JSON‑based data.

Multi-Valued Indexesindexesmysql
0 likes · 12 min read
Unlock MySQL JSON: Design, Index, and Query Strategies for Dynamic Data
JavaEdge
JavaEdge
Dec 10, 2021 · Databases

Master MySQL Interview Questions: ACID, Indexes, Transactions, and More

This comprehensive guide covers MySQL fundamentals such as ACID transaction properties, isolation levels, index types and design principles, storage engines, MVCC mechanics, query execution flow, replication, locking strategies, and performance‑tuning techniques for large tables and complex queries.

indexesinterviewmysql
0 likes · 39 min read
Master MySQL Interview Questions: ACID, Indexes, Transactions, and More
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 OptimizationQuery TuningTransactions
0 likes · 14 min read
MySQL Optimization: Concepts, Schema Design, Indexes, and Query Tuning
Ops Development Stories
Ops Development Stories
Nov 12, 2021 · Databases

Unlock MySQL Performance: Mastering EXPLAIN Execution Plans

This article explains what an execution plan is, how to use the EXPLAIN keyword in MySQL 5.7, interprets each column of the EXPLAIN output—including id, select_type, table, type, possible_keys, key, key_len, rows, and Extra—provides detailed examples of different query scenarios, and shows how optimizer settings like derived_merge affect the plan.

Derived Tablesexecution planexplain
0 likes · 20 min read
Unlock MySQL Performance: Mastering EXPLAIN Execution Plans
NiuNiu MaTe
NiuNiu MaTe
Oct 21, 2021 · Databases

Master MySQL ACID, Isolation Levels, Locks & Indexes – A Deep Dive

This article walks through MySQL's core concepts—including ACID guarantees, the four isolation levels, undo and redo logs, buffer pool flushing, lock types, gap locks, deadlock scenarios, and the B+‑tree based index architecture—providing interview‑ready insights and practical examples.

ACIDB+TreeDatabase Interview
0 likes · 12 min read
Master MySQL ACID, Isolation Levels, Locks & Indexes – A Deep Dive
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Sep 14, 2021 · Databases

Common MySQL Interview Questions and Answers

This article provides a comprehensive collection of typical MySQL interview questions covering storage engines, lock types, gap locks, deadlock avoidance, isolation levels, index types, covering indexes, left‑most prefix rule, replication, distributed transactions, optimization techniques, sharding challenges and solutions, and global unique ID generation.

LocksReplicationdatabase
0 likes · 15 min read
Common MySQL Interview Questions and Answers
Wukong Talks Architecture
Wukong Talks Architecture
Sep 1, 2021 · Databases

Understanding MySQL EXPLAIN Output: Columns and Their Meaning

This article explains the purpose and interpretation of each column in MySQL's EXPLAIN output, covering identifiers, select types, table sources, partition info, access types, possible keys, actual keys, key lengths, row estimates, filtering percentages, and extra execution details, with visual examples and code snippets.

Query ExecutionSQLexplain
0 likes · 10 min read
Understanding MySQL EXPLAIN Output: Columns and Their Meaning
Selected Java Interview Questions
Selected Java Interview Questions
Aug 30, 2021 · Databases

MySQL Interview Questions and Answers: Indexes, InnoDB vs MyISAM, Transactions, Optimization, and Design

This article compiles a comprehensive set of MySQL interview questions covering index types, the differences between MyISAM and InnoDB, the rationale for auto‑increment primary keys, sharding strategies, ACID properties, isolation levels, storage‑engine trade‑offs, normalization, index best practices, data types, performance tuning, locking mechanisms, B+Tree characteristics, and common SQL operations.

Database designInnoDBSQL
0 likes · 28 min read
MySQL Interview Questions and Answers: Indexes, InnoDB vs MyISAM, Transactions, Optimization, and Design
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.

Database PerformanceQuery TuningSQL Optimization
0 likes · 13 min read
MySQL Query Optimization Techniques and Common Pitfalls
IT Xianyu
IT Xianyu
Aug 17, 2021 · Databases

Key New Features of MySQL 8.0 for Relational Databases

MySQL 8.0 introduces several relational‑database enhancements, including invisible indexes for performance tuning, persistent configuration via SET PERSIST, default utf8mb4 character set, support for Common Table Expressions, and window functions, each illustrated with practical SQL examples.

8.0CTESQL
0 likes · 7 min read
Key New Features of MySQL 8.0 for Relational Databases
dbaplus Community
dbaplus Community
Aug 11, 2021 · Databases

Turn Slow MySQL Queries into Millisecond Performance with Smart Rewrites

This article explains common MySQL performance pitfalls such as large‑offset LIMIT, implicit type conversion, sub‑query updates, mixed ordering, EXISTS clauses, and condition pushdown, and shows how to rewrite each pattern using indexes, JOINs, UNION ALL, CTEs and early filtering to achieve execution times measured in milliseconds instead of seconds.

CTEJOINSQL Optimization
0 likes · 13 min read
Turn Slow MySQL Queries into Millisecond Performance with Smart Rewrites
Open Source Linux
Open Source Linux
Aug 8, 2021 · Databases

MongoDB Essentials: 52 Common Questions Answered

This comprehensive guide covers everything from MongoDB's core concepts, data model, and architecture to practical commands for creating databases, collections, indexes, sharding, replication, aggregation, and troubleshooting, providing clear answers to over fifty frequently asked questions.

MongoDBNoSQLReplication
0 likes · 27 min read
MongoDB Essentials: 52 Common Questions Answered
ITPUB
ITPUB
Jul 28, 2021 · Databases

Master MySQL Performance: Essential SQL Optimization Techniques & Index Strategies

This comprehensive guide walks you through MySQL performance tuning, covering how to monitor server status, identify slow queries, use EXPLAIN for execution plans, create and manage various index types, and apply practical SQL optimizations such as import tricks, insert batching, efficient GROUP BY/ORDER BY, and pagination improvements.

SQL OptimizationSlow Query Logexplain
0 likes · 25 min read
Master MySQL Performance: Essential SQL Optimization Techniques & Index Strategies
Architect
Architect
Jul 21, 2021 · Databases

MySQL 100 Interview Questions: Indexes, Transactions, Table Design, and Storage Engines

This article compiles 100 common MySQL interview questions for developers, covering index structures and optimization, transaction ACID properties and isolation levels, primary‑key design, storage‑engine choices, sharding strategies, and miscellaneous SQL nuances such as binlog formats and MyBatis parameter handling.

SQLStorage Enginesindexes
0 likes · 20 min read
MySQL 100 Interview Questions: Indexes, Transactions, Table Design, and Storage Engines
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.

Performance OptimizationQuery TuningSQL
0 likes · 16 min read
52 SQL Statement Performance Optimization Strategies
Top Architect
Top Architect
Jul 17, 2021 · Databases

Understanding MySQL Query Optimization and Index Design

This article explains MySQL’s logical architecture, query processing steps, and the principles behind query optimization, covering topics such as client‑server protocol, query cache, parsing, cost‑based optimizer, execution engine, and practical index design strategies to improve performance.

Database PerformanceSQLindexes
0 likes · 35 min read
Understanding MySQL Query Optimization and Index Design
Top Architect
Top Architect
Jun 19, 2021 · Databases

SQL Query Performance Optimization Tips

This article provides a comprehensive collection of practical MySQL and SQL performance optimization techniques, covering index usage, query rewriting, avoiding full table scans, proper data types, efficient joins, backup strategies, and other best practices to improve database speed and reliability.

SQLdatabaseindexes
0 likes · 18 min read
SQL Query Performance Optimization Tips
Java Architect Essentials
Java Architect Essentials
Jun 18, 2021 · Databases

How to Supercharge MySQL Queries: 8 Proven Optimization Techniques

This article walks through eight common MySQL performance pitfalls—including inefficient LIMIT usage, implicit type conversion, sub‑query updates, mixed sorting, EXISTS clauses, condition push‑down, early range reduction, and intermediate result push‑down—and shows how to rewrite each query to achieve dramatic speed improvements, often reducing execution time from seconds to milliseconds.

Condition PushdownJOINSQL Optimization
0 likes · 14 min read
How to Supercharge MySQL Queries: 8 Proven Optimization Techniques
php Courses
php Courses
May 19, 2021 · Databases

Fundamentals of Relational Databases: Key Concepts and Common Questions

This article provides a comprehensive overview of relational database fundamentals, covering common DBMS products, SQL language components, integrity constraints, transactions, locking, views, stored procedures, indexes, normalization, key differences, constraints, optimization techniques, storage engines, and performance strategies for high‑traffic sites.

Database OptimizationRelational DatabaseTransactions
0 likes · 12 min read
Fundamentals of Relational Databases: Key Concepts and Common Questions
Java Architect Essentials
Java Architect Essentials
May 11, 2021 · Databases

Comprehensive MySQL Query Optimization and Best Practices

This article presents an extensive collection of MySQL performance‑tuning techniques, covering index design, query rewriting, use of UNION and EXISTS, temporary tables, NOLOCK hints, join limits, backup strategies, storage engine choices, data‑type selection, and other practical tips to improve query efficiency and overall database reliability.

Database designSQL Optimizationindexes
0 likes · 18 min read
Comprehensive MySQL Query Optimization and Best Practices
Liangxu Linux
Liangxu Linux
Apr 26, 2021 · Databases

Master MySQL Internals: Query Cache, Indexes, Optimizer & Transaction Logs

This article explains MySQL's query cache settings, clustered and non‑clustered index design, optimizer cost calculations, how to interpret EXPLAIN output, and the roles of redo/undo logs and transaction isolation levels, providing practical examples and performance tips.

Isolation LevelsTransaction Logsindexes
0 likes · 23 min read
Master MySQL Internals: Query Cache, Indexes, Optimizer & Transaction Logs
Selected Java Interview Questions
Selected Java Interview Questions
Apr 22, 2021 · Databases

Key MySQL Concepts: DROP/DELETE/TRUNCATE, Data Types, Storage Engines, Transactions, Views, Procedures, Indexes, UNION, and SQL Language Parts

This article explains the differences between DROP, DELETE, and TRUNCATE, recommends appropriate MySQL data types for monetary values, compares MyISAM and InnoDB storage engines, outlines transaction ACID properties, describes views, stored procedures versus triggers, indexes, UNION vs UNION ALL, and lists the main SQL language categories.

SQLStorage EnginesStored Procedures
0 likes · 10 min read
Key MySQL Concepts: DROP/DELETE/TRUNCATE, Data Types, Storage Engines, Transactions, Views, Procedures, Indexes, UNION, and SQL Language Parts
Java Interview Crash Guide
Java Interview Crash Guide
Mar 24, 2021 · Databases

Top 20 Proven Techniques to Optimize Your Database Performance

This article compiles essential database optimization strategies—including proper index creation, composite and short indexes, avoiding full‑table scans, efficient use of temporary tables and cursors, and best practices for query writing—to dramatically improve query speed and overall system throughput.

SQL Performancecursorsindexes
0 likes · 11 min read
Top 20 Proven Techniques to Optimize Your Database Performance
Architecture Digest
Architecture Digest
Mar 21, 2021 · Databases

MySQL Interview Essentials: Indexes, Transactions, Storage Engines, and Schema Design

This article compiles a comprehensive set of MySQL interview questions covering index structures, B‑tree vs. hash trade‑offs, primary‑key and clustered‑index design, ACID properties, isolation levels, lock types, storage‑engine choices, data‑type considerations, binlog formats, pagination strategies, sharding, stored procedures, normalization, and MyBatis parameter syntax.

Database designSQL OptimizationStorage Engines
0 likes · 20 min read
MySQL Interview Essentials: Indexes, Transactions, Storage Engines, and Schema Design
Top Architect
Top Architect
Feb 26, 2021 · Databases

52 Practical SQL Query Performance Optimization Strategies

This article compiles fifty‑two actionable tips for improving SQL query performance, covering index creation, query rewriting, use of temporary tables, proper data types, server configuration, and best practices for MySQL and other relational databases.

SQLindexesoptimization
0 likes · 18 min read
52 Practical SQL Query Performance Optimization Strategies
Laravel Tech Community
Laravel Tech Community
Feb 18, 2021 · Databases

Why NULL Columns Can Break MySQL Indexes and How to Avoid It

This article explains how MySQL treats NULL values, why columns defined with NULL can invalidate indexes, demonstrates the behavior of IS NULL, IS NOT NULL, the spaceship operator, IFNULL, COUNT, DISTINCT, GROUP BY and ORDER BY with NULLs, and offers practical recommendations for schema design.

Database designNULLSQL
0 likes · 13 min read
Why NULL Columns Can Break MySQL Indexes and How to Avoid It
Java Captain
Java Captain
Feb 14, 2021 · Databases

52 SQL Statement Performance Optimization Strategies

This article presents a comprehensive collection of 52 practical tips for optimizing SQL queries, covering index usage, query rewriting, data type selection, storage engine choices, transaction handling, and backup strategies to improve database performance and reduce resource consumption.

SQLindexesoptimization
0 likes · 18 min read
52 SQL Statement Performance Optimization Strategies
Laravel Tech Community
Laravel Tech Community
Jan 24, 2021 · Databases

MySQL Slow Query Optimization: Reducing Execution Time from 30 Seconds to 0.19 Seconds

This article documents a MySQL slow‑query case where a 5‑million‑row table took over 30 seconds to execute, explores several ineffective optimization attempts, uncovers a client‑side LIMIT issue, and finally resolves the performance problem by forcing the use of the idx_end_time index, cutting the runtime to under a second.

SQL Optimizationdatabaseexecution plan
0 likes · 5 min read
MySQL Slow Query Optimization: Reducing Execution Time from 30 Seconds to 0.19 Seconds
Java Interview Crash Guide
Java Interview Crash Guide
Jan 10, 2021 · Databases

Boost MySQL Query Speed: Practical SQL Optimization Tips for 2021

This article explains why SQL performance is critical for fast‑response web services, presents database‑agnostic optimization techniques—such as preferring EXISTS over IN, using JOINs, avoiding unnecessary ORDER BY, leveraging UNION ALL, and applying indexes—to dramatically reduce query latency and resource consumption.

SQLindexesmysql
0 likes · 15 min read
Boost MySQL Query Speed: Practical SQL Optimization Tips for 2021
ITPUB
ITPUB
Jan 7, 2021 · Databases

52 Proven SQL Performance Optimization Techniques You Must Use

This article compiles 52 practical SQL performance‑tuning strategies—including index best practices, query rewrites, use of temporary tables, proper data types, and server configuration tips—to help developers dramatically speed up MySQL and other relational database queries while avoiding common pitfalls.

SQLindexesmysql
0 likes · 19 min read
52 Proven SQL Performance Optimization Techniques You Must Use
Liangxu Linux
Liangxu Linux
Jan 6, 2021 · Databases

52 Proven SQL Performance Tweaks to Supercharge Your Queries

This article compiles 52 practical SQL optimization strategies—including index usage, query rewriting, avoiding full table scans, proper data types, and server configuration tips—to help developers dramatically improve query speed and overall database performance.

SQLindexesmysql
0 likes · 22 min read
52 Proven SQL Performance Tweaks to Supercharge Your Queries
21CTO
21CTO
Jan 5, 2021 · Databases

5 Essential Rules for Writing High‑Performance SQL Queries

This article presents five practical rules—return only needed rows, use proper indexes, avoid subqueries, replace OFFSET pagination with key‑based limits, and understand SQL's logical execution order—to help developers write efficient, high‑performance SQL queries across major relational databases.

SQLSubqueryindexes
0 likes · 13 min read
5 Essential Rules for Writing High‑Performance SQL Queries
Architect
Architect
Jan 5, 2021 · Databases

MySQL Index Fundamentals: Types, Structures, and Design Principles

This article introduces MySQL index basics, covering index concepts, advantages and disadvantages, various index types such as B‑Tree, B+Tree, hash, and full‑text, their storage structures, creation syntax, left‑most prefix and covering indexes, and practical design guidelines for effective indexing.

B-TreeDatabase OptimizationSQL
0 likes · 22 min read
MySQL Index Fundamentals: Types, Structures, and Design Principles
Code Ape Tech Column
Code Ape Tech Column
Jan 5, 2021 · Databases

5 Essential Rules for Writing High‑Performance SQL Queries

This article explains why SQL query optimization matters and presents five practical rules—return only needed rows, use the right indexes, avoid subqueries, replace OFFSET‑based pagination, and master the logical execution order—to help developers write faster, more efficient database queries across major relational systems.

SQLdatabaseindexes
0 likes · 14 min read
5 Essential Rules for Writing High‑Performance SQL Queries
Practical DevOps Architecture
Practical DevOps Architecture
Jan 4, 2021 · Databases

New MySQL 8 Features: Invisible Indexes, Persistent Settings, UTF8MB4, CTEs, and Window Functions

This article introduces several MySQL 8 enhancements—including invisible indexes for performance testing, the SET PERSIST command for durable configuration changes, default UTF8MB4 encoding, Common Table Expressions for clearer queries, and window functions for ranking and aggregation—illustrated with practical SQL examples.

CTEWindow Functionsindexes
0 likes · 6 min read
New MySQL 8 Features: Invisible Indexes, Persistent Settings, UTF8MB4, CTEs, and Window Functions
Laravel Tech Community
Laravel Tech Community
Jan 3, 2021 · Databases

52 SQL Query Performance Optimization Strategies

This article presents a comprehensive collection of 52 practical SQL performance optimization techniques, covering indexing, query rewriting, use of EXISTS, avoiding full table scans, proper handling of NULLs, OR/IN clauses, temporary tables, storage engine choices, backup procedures, and other best practices to improve database efficiency.

SQLdatabaseindexes
0 likes · 18 min read
52 SQL Query Performance Optimization Strategies
ITPUB
ITPUB
Jan 3, 2021 · Databases

5 Essential Rules for Writing High‑Performance SQL Queries

This article presents five practical rules for optimizing SQL queries—including selecting only needed columns, ensuring proper indexes, avoiding subqueries, using keyset pagination instead of OFFSET, and understanding the logical execution order—along with concrete examples and execution‑plan analysis for major relational databases.

SQLexecution planindexes
0 likes · 14 min read
5 Essential Rules for Writing High‑Performance SQL Queries
Su San Talks Tech
Su San Talks Tech
Dec 24, 2020 · Databases

Master MySQL: Deep Dive into Execution Flow, Logs, Indexes, Transactions, and Optimization

This comprehensive guide explains MySQL's server and storage engine layers, SQL execution order, BinLog/RedoLog/UndoLog mechanisms, index structures and design principles, transaction isolation levels, lock types, MVCC, buffer pool behavior, table slimming, join strategies, statistics, random queries, and practical optimization techniques for high‑performance database operations.

Database InternalsSQLindexes
0 likes · 43 min read
Master MySQL: Deep Dive into Execution Flow, Logs, Indexes, Transactions, and Optimization
Laravel Tech Community
Laravel Tech Community
Dec 17, 2020 · Databases

Understanding Index Usage and Slow Queries in MySQL

This article explains why using indexes in MySQL does not always prevent slow queries, analyzes full‑index scans, index selectivity, back‑table lookups, virtual columns, and provides practical optimization techniques to reduce scanned rows and improve performance.

Database PerformanceSlow QueriesVirtual Columns
0 likes · 11 min read
Understanding Index Usage and Slow Queries in MySQL
ITPUB
ITPUB
Dec 17, 2020 · Databases

5 Essential Rules to Write High‑Performance SQL Queries

This article presents five practical rules for writing efficient SQL queries—including selecting only needed rows, using proper indexes, avoiding subqueries, replacing OFFSET pagination, and understanding the logical execution order—supported by examples, execution plans, and performance tips for various relational databases.

SQLindexesperformance
0 likes · 14 min read
5 Essential Rules to Write High‑Performance SQL Queries
Java Backend Technology
Java Backend Technology
Dec 15, 2020 · Databases

Deep Dive into MySQL: Execution Flow, Logs, Locks, MVCC, and Performance Tuning

This comprehensive guide explores MySQL’s internal architecture, covering the SQL execution process, server and storage engine layers, binlog, redo and undo logs, index structures, transaction isolation levels, lock mechanisms, MVCC implementation, buffer pool management, table optimization, query techniques, and advanced performance tuning strategies.

MVCCindexesmysql
0 likes · 35 min read
Deep Dive into MySQL: Execution Flow, Logs, Locks, MVCC, and Performance Tuning
Code Ape Tech Column
Code Ape Tech Column
Dec 15, 2020 · Databases

Why Indexes Still Lead to Slow Queries and How to Optimize Them

Even when a MySQL query uses an index, it can still become a slow query; this article explains index structures, explains why full‑index scans and poor selectivity cause performance issues, and presents step‑by‑step optimization techniques such as index condition pushdown, virtual columns, and better filtering.

SQLdatabaseindexes
0 likes · 13 min read
Why Indexes Still Lead to Slow Queries and How to Optimize Them
Top Architect
Top Architect
Dec 14, 2020 · Databases

Understanding MySQL Query Execution and Optimization Techniques

This article explains MySQL’s logical architecture, query processing steps, caching mechanisms, index structures, and provides practical performance‑tuning advice—including schema design, index creation, query rewriting, and pagination—helping readers grasp the underlying principles and apply effective optimizations in real‑world workloads.

databaseindexesmysql
0 likes · 34 min read
Understanding MySQL Query Execution and Optimization Techniques
ITPUB
ITPUB
Dec 11, 2020 · Databases

Master MySQL: 100 Essential Q&A on Indexes, Transactions, and Design

This comprehensive guide answers the most frequent MySQL interview questions, covering index structures, transaction isolation levels, table design best practices, storage engine differences, query optimization techniques, and miscellaneous topics such as data types, binlog formats, and sharding strategies.

Database designStorage EnginesTransactions
0 likes · 23 min read
Master MySQL: 100 Essential Q&A on Indexes, Transactions, and Design
ITPUB
ITPUB
Nov 30, 2020 · Databases

How to Fix Common MySQL Performance Pitfalls: Real-World SQL Optimizations

This article examines frequent MySQL performance problems such as inefficient LIMIT usage, implicit type conversion, subquery updates, mixed ordering, EXISTS clauses, predicate push‑down, early row reduction, and intermediate result set handling, providing concrete rewrites and execution‑plan comparisons that dramatically improve query speed.

Query PlanningSQL OptimizationSubqueries
0 likes · 14 min read
How to Fix Common MySQL Performance Pitfalls: Real-World SQL Optimizations
Top Architect
Top Architect
Nov 24, 2020 · Databases

SQL Query Optimization Rules and Best Practices

This article presents five practical rules for writing efficient SQL queries—including using precise WHERE clauses, creating appropriate indexes, avoiding costly subqueries, replacing OFFSET‑based pagination with key‑based limits, and understanding the logical execution order of SQL clauses—to help developers improve database performance across major relational systems.

SQLdatabaseindexes
0 likes · 14 min read
SQL Query Optimization Rules and Best Practices
Senior Brother's Insights
Senior Brother's Insights
Nov 23, 2020 · Databases

Master MySQL Indexes: Types, Structures, and Optimization Strategies

This article explains the fundamental concepts and practical design of MySQL indexes, covering implementation-level index types, application-level index categories, the differences between clustered and non‑clustered indexes, B‑Tree and hash structures, covering indexes, and best‑practice strategies for optimal query performance.

B+TreeClustered IndexHash Index
0 likes · 14 min read
Master MySQL Indexes: Types, Structures, and Optimization Strategies
Top Architect
Top Architect
Nov 20, 2020 · Databases

Database Design and SQL Best‑Practice Guidelines

This article presents a comprehensive set of mandatory and recommended MySQL database standards—including table creation rules, SQL writing conventions, and index design practices—aimed at preventing improper schemas, reducing erroneous queries, and improving overall performance for backend development teams.

Database designSQL Guidelinesindexes
0 likes · 14 min read
Database Design and SQL Best‑Practice Guidelines
ITPUB
ITPUB
Nov 13, 2020 · Databases

Master MySQL Indexes: How Explain Optimizes Query Performance

This guide explains why MySQL queries become slow, how to diagnose issues with slow‑query logs, Explain and Show Profile, details the structure and types of indexes, interprets each column of the Explain output, and demonstrates practical optimization steps with real SQL examples.

Database PerformanceSQLindexes
0 likes · 14 min read
Master MySQL Indexes: How Explain Optimizes Query Performance
ITPUB
ITPUB
Nov 10, 2020 · Databases

Essential SQL Server Cheat Sheet: 80+ Queries for Administration and Monitoring

This comprehensive cheat sheet gathers over eighty practical T‑SQL statements covering instance properties, configuration, system views, lock monitoring, backup progress, replication, Always On, FILESTREAM, job management, index maintenance, and security, providing DBAs with ready‑to‑run commands for everyday SQL Server administration and troubleshooting.

Database AdministrationReplicationSQL Server
0 likes · 29 min read
Essential SQL Server Cheat Sheet: 80+ Queries for Administration and Monitoring
dbaplus Community
dbaplus Community
Nov 7, 2020 · Databases

How OpenGauss Handles Oracle Objects: Indexes, Constraints, Views, and More

This article evaluates the compatibility of Oracle logical objects—indexes, constraints, views, sequences, and synonyms—in openGauss, detailing each object type, providing concrete SQL examples, highlighting differences such as bitmap index support, and summarizing the overall compatibility in a concise table.

ConstraintsOracle compatibilitySequences
0 likes · 11 min read
How OpenGauss Handles Oracle Objects: Indexes, Constraints, Views, and More
Programmer DD
Programmer DD
Nov 3, 2020 · Databases

Why Using Indexes Doesn’t Guarantee Fast Queries – MySQL Index Deep Dive

This article explains why a MySQL query that uses an index can still become a slow query, explores the difference between index usage and execution time, and presents practical optimization techniques such as improving selectivity, reducing back‑table lookups, using index condition push‑down, and leveraging virtual columns.

Virtual Columnsdatabaseindexes
0 likes · 13 min read
Why Using Indexes Doesn’t Guarantee Fast Queries – MySQL Index Deep Dive
Liangxu Linux
Liangxu Linux
Nov 1, 2020 · Databases

100 MySQL Interview Q&A: Indexes, Transactions, and Schema Design Essentials

This article compiles 100 common MySQL interview questions covering index structures, hash vs B‑tree trade‑offs, clustering, transaction isolation levels, lock types, primary key choices, storage engines, data types, binlog formats, pagination strategies, and best practices for schema design and query optimization.

SQLStorage EngineTransactions
0 likes · 21 min read
100 MySQL Interview Q&A: Indexes, Transactions, and Schema Design Essentials
Laravel Tech Community
Laravel Tech Community
Oct 28, 2020 · Databases

Common MySQL Query Performance Pitfalls and Their Optimizations

This article examines frequent MySQL performance problems such as inefficient LIMIT usage, implicit type conversion, sub‑query updates, mixed ordering, EXISTS clauses, condition push‑down, early limiting, intermediate result push‑down, and demonstrates how rewriting queries with proper indexes, JOINs, UNION, and WITH statements can dramatically reduce execution time.

SQL Optimizationdatabaseindexes
0 likes · 12 min read
Common MySQL Query Performance Pitfalls and Their Optimizations
ITPUB
ITPUB
Oct 28, 2020 · Databases

Top MySQL Interview Questions: Data Types, Indexes, Joins, and Performance Tuning

This article compiles essential MySQL interview questions covering data types, storage engines, locks, transactions, triggers, index creation and usage, join types, and practical SQL optimization techniques with concrete examples and code snippets for developers to master database fundamentals.

SQLindexesinterview
0 likes · 35 min read
Top MySQL Interview Questions: Data Types, Indexes, Joins, and Performance Tuning
Programmer DD
Programmer DD
Oct 28, 2020 · Databases

Master MySQL Performance: Essential Database Optimization Techniques

This guide explains how to identify bottlenecks and boost MySQL performance through both soft (query, index, schema) and hard (hardware, configuration, sharding, caching) optimizations, offering practical commands, best‑practice tips, and visual illustrations for each step.

Database OptimizationSQLindexes
0 likes · 9 min read
Master MySQL Performance: Essential Database Optimization Techniques
Architecture Digest
Architecture Digest
Oct 15, 2020 · Databases

Understanding MySQL Indexes: B‑Tree, B+Tree, and Index Design Principles

This article explains how MySQL indexes work, compares binary trees, B‑Tree and B+Tree structures, describes their implementation in MyISAM and InnoDB storage engines, and provides practical guidelines for creating efficient single‑column, composite, and covering indexes to improve query performance.

B+TreeDatabase OptimizationSQL
0 likes · 17 min read
Understanding MySQL Indexes: B‑Tree, B+Tree, and Index Design Principles
Open Source Linux
Open Source Linux
Oct 14, 2020 · Databases

100 MySQL Interview Questions: Indexes, Transactions, and Storage Engines Explained

This article presents a curated list of 100 essential MySQL interview questions covering indexes, transaction fundamentals, storage engine differences, table design, query optimization, and common pitfalls, providing concise explanations and practical examples to deepen developers’ understanding and prepare them for technical interviews.

Database designSQL OptimizationStorage Engines
0 likes · 23 min read
100 MySQL Interview Questions: Indexes, Transactions, and Storage Engines Explained
Selected Java Interview Questions
Selected Java Interview Questions
Oct 3, 2020 · Databases

SQL Query Optimization Tips and Common Pitfalls

This article presents a comprehensive collection of SQL query optimization techniques, covering index usage, avoiding full table scans, proper handling of NULLs, functions, LIKE patterns, temporary tables, cursors, and other best practices to improve database performance and maintainability.

Database OptimizationSQLindexes
0 likes · 11 min read
SQL Query Optimization Tips and Common Pitfalls
Java Captain
Java Captain
Sep 26, 2020 · Databases

MySQL Performance Optimization Techniques: LIMIT, Implicit Conversion, Join Rewrite, Mixed Sorting, EXISTS, Condition Pushdown, and More

This article explains common MySQL performance pitfalls such as large OFFSET in LIMIT clauses, implicit type conversion, sub‑query updates, mixed sorting, EXISTS usage, condition push‑down limitations, and demonstrates how rewriting queries with indexes, JOINs, UNION ALL, and WITH clauses can dramatically reduce execution time.

JOINSQL Optimizationindexes
0 likes · 14 min read
MySQL Performance Optimization Techniques: LIMIT, Implicit Conversion, Join Rewrite, Mixed Sorting, EXISTS, Condition Pushdown, and More
Top Architect
Top Architect
Sep 22, 2020 · Databases

Understanding MySQL Query Execution and Optimization Techniques

This article explains MySQL’s logical architecture, query processing stages, client‑server protocol, query cache, parsing, optimization, execution engine, and provides practical performance‑tuning advice such as index design, data‑type choices, covering indexes, limit pagination, and handling UNION and JOIN operations.

Database PerformanceSQLindexes
0 likes · 35 min read
Understanding MySQL Query Execution and Optimization Techniques
Architects Research Society
Architects Research Society
Sep 2, 2020 · Databases

Scaling PostgreSQL for Multi‑Terabyte Databases: Indexes, Partitioning, Tablespaces, Parallelism, and Replication

This article explains how to extract maximum performance and scalability from PostgreSQL for multi‑terabyte workloads by leveraging specialized indexes, declarative partitioning, tablespaces, parallel query execution, read‑only replica load‑balancing, and foreign‑table sharding techniques.

ParallelismPartitioningPostgreSQL
0 likes · 10 min read
Scaling PostgreSQL for Multi‑Terabyte Databases: Indexes, Partitioning, Tablespaces, Parallelism, and Replication
ITPUB
ITPUB
Aug 31, 2020 · Databases

Mastering MySQL: Keys, Indexes, Transactions, Storage Engines, and Optimization Explained

This comprehensive guide covers MySQL fundamentals—including primary, foreign, candidate, and super keys—auto‑increment primary keys, triggers, stored procedures, views, cursor usage, index types and design, transaction properties and isolation levels, storage engine differences, query execution order, EXPLAIN analysis, lock mechanisms, replication strategies, high‑concurrency solutions, and crash‑recovery via REDO and UNDO logs, providing practical examples and code snippets for each concept.

Database FundamentalsSQL OptimizationStorage Engines
0 likes · 52 min read
Mastering MySQL: Keys, Indexes, Transactions, Storage Engines, and Optimization Explained
DevOps Coach
DevOps Coach
Aug 1, 2020 · Databases

Boost PostgreSQL Performance: Essential DBA Tricks Every Developer Should Know

This article presents a collection of practical PostgreSQL DBA techniques—including selective updates, bulk‑load optimizations, CTE‑based deduplication, partial and BRIN indexes, correlation tuning, and transactional DDL tricks—to help developers reduce database bottlenecks, improve query speed, and avoid common performance pitfalls.

BRINCTEDevOps
0 likes · 33 min read
Boost PostgreSQL Performance: Essential DBA Tricks Every Developer Should Know
JavaEdge
JavaEdge
Jul 25, 2020 · Databases

Should You Use Unique Indexes in MySQL? Performance Impact of Change Buffer

This article explains the differences between normal and unique indexes in MySQL, examines how they affect query and update performance, details InnoDB's change‑buffer mechanism, and provides practical guidance on when to prefer ordinary indexes for better write efficiency.

Change BufferInnoDBUnique Index
0 likes · 13 min read
Should You Use Unique Indexes in MySQL? Performance Impact of Change Buffer
ITPUB
ITPUB
Jul 15, 2020 · Databases

Master MySQL Performance: Indexes, EXPLAIN, and Slow‑Query Optimization

This guide compiles essential MySQL optimization techniques—including index cardinality, function indexes, EXPLAIN usage, covering indexes, ICP, slow‑query log analysis, online schema changes, and common SQL pitfalls—to help developers efficiently tune database performance.

Database OptimizationSQLexplain
0 likes · 19 min read
Master MySQL Performance: Indexes, EXPLAIN, and Slow‑Query Optimization
macrozheng
macrozheng
Jul 14, 2020 · Databases

Why SELECT * Slows Down MySQL: Deep Dive into Indexes and Optimization

This article explains why using SELECT * in MySQL queries degrades performance, covering increased parsing cost, unnecessary data transfer, loss of covering index optimization, and how proper column selection and index design can dramatically improve query speed.

Database PerformanceSQL Optimizationcovering index
0 likes · 10 min read
Why SELECT * Slows Down MySQL: Deep Dive into Indexes and Optimization
Laravel Tech Community
Laravel Tech Community
Jun 11, 2020 · Databases

MySQL Performance Optimization Techniques: Bulk Inserts, INSERT, GROUP BY, ORDER BY, OR, Nested Queries, and SQL Hints

This article presents a comprehensive guide to MySQL performance tuning, covering bulk‑insert optimizations, efficient INSERT statements, GROUP BY and ORDER BY improvements, OR‑condition handling, nested query replacement, and the use of SQL hints such as USE INDEX, IGNORE INDEX, and FORCE INDEX, with practical code examples and benchmark results.

Bulk InsertDatabase PerformanceQuery Tuning
0 likes · 13 min read
MySQL Performance Optimization Techniques: Bulk Inserts, INSERT, GROUP BY, ORDER BY, OR, Nested Queries, and SQL Hints
Selected Java Interview Questions
Selected Java Interview Questions
Jun 8, 2020 · Databases

Comprehensive MySQL Interview Guide: Concepts, Indexes, Transactions, Storage Engines, and Optimization

This article provides an extensive overview of MySQL fundamentals for interview preparation, covering primary key concepts, index types and usage, transaction properties and isolation levels, storage engine differences, query execution order, performance tuning with EXPLAIN, lock mechanisms, replication strategies, and high‑concurrency solutions.

Storage EnginesTransactionsdatabase
0 likes · 49 min read
Comprehensive MySQL Interview Guide: Concepts, Indexes, Transactions, Storage Engines, and Optimization
Selected Java Interview Questions
Selected Java Interview Questions
Jun 5, 2020 · Databases

MySQL Query Optimization Techniques and Common Pitfalls

This article explains MySQL execution order, highlights performance problems with large OFFSET LIMIT queries, demonstrates how implicit type conversion, sub‑query rewriting, EXISTS removal, condition push‑down, and intermediate result push‑down can dramatically improve query speed, and provides practical SQL rewrite examples.

JOINLIMITSQL Optimization
0 likes · 13 min read
MySQL Query Optimization Techniques and Common Pitfalls
macrozheng
macrozheng
Jun 3, 2020 · Databases

Master MySQL EXPLAIN: Decode Execution Plans for Faster Queries

This article explains the purpose of the MySQL EXPLAIN command, details each column in its output (id, select_type, table, type, possible_keys, etc.), provides real‑world SQL examples, and shows how to interpret the plan to identify indexing, join, and sorting issues for query optimization.

Query PlanSQL Optimizationexplain
0 likes · 18 min read
Master MySQL EXPLAIN: Decode Execution Plans for Faster Queries
Selected Java Interview Questions
Selected Java Interview Questions
May 7, 2020 · Databases

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

This article explains MySQL's core architecture, lock and transaction mechanisms, storage engines, and provides practical creation‑time and query‑time optimization techniques such as proper data types, index selection, query rewriting, and performance analysis using EXPLAIN, supplemented with concrete SQL examples.

Database OptimizationTransactionsindexes
0 likes · 10 min read
MySQL Fundamentals and Optimization: Concepts, Schema Design, Indexes, and Query Tuning
Architecture Digest
Architecture Digest
Apr 30, 2020 · Databases

Understanding MySQL Query Optimization and Performance Tuning

This article explains MySQL's logical architecture, query processing steps, and the underlying principles of query optimization, covering topics such as client‑server protocol, query cache, parsing, optimizer cost model, index structures, and practical performance‑tuning strategies for efficient database operations.

indexesmysqlquery optimization
0 likes · 33 min read
Understanding MySQL Query Optimization and Performance Tuning
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 29, 2020 · Databases

Understanding MySQL Field Attributes: NULL, NOT NULL, and AUTO_INCREMENT Performance Considerations

This article examines MySQL column attributes—especially NULL vs NOT NULL handling, the impact of NULL on concatenation, COUNT and indexing, as well as AUTO_INCREMENT behaviors, lock modes, step/offset settings, and overflow scenarios—to help developers write more efficient and reliable SQL.

Database PerformanceNULLauto_increment
0 likes · 10 min read
Understanding MySQL Field Attributes: NULL, NOT NULL, and AUTO_INCREMENT Performance Considerations
ITPUB
ITPUB
Apr 22, 2020 · Databases

Master Oracle Database Essentials: Startup, Users, Tablespaces, Indexes & More

This guide walks through essential Oracle Database administration tasks, covering how to start and shut down the database and listener, create and manage tablespaces, users, and permissions, control transactions, build and maintain indexes, views, materialized views, sequences, synonyms, and partitioned tables, with command examples and best‑practice tips.

Database AdministrationOraclePartitioning
0 likes · 21 min read
Master Oracle Database Essentials: Startup, Users, Tablespaces, Indexes & More
Big Data Technology & Architecture
Big Data Technology & Architecture
Apr 12, 2020 · Databases

Comprehensive MySQL Fundamentals and Advanced Topics Overview

This extensive guide covers MySQL fundamentals and advanced concepts, including storage engines, data types, indexes, transactions, isolation levels, locking mechanisms, views, stored procedures, triggers, SQL optimization techniques, replication, backup strategies, and sharding approaches for high‑availability and scalability.

Database FundamentalsTransactionsindexes
0 likes · 73 min read
Comprehensive MySQL Fundamentals and Advanced Topics Overview
21CTO
21CTO
Mar 18, 2020 · Databases

Master MySQL: Key Differences, Index Types, and Performance Tips

This article explains the distinctions between UNION and UNION ALL, TRUNCATE and DELETE, TIMESTAMP and DATETIME, introduces composite and covering indexes, describes InnoDB versus MyISAM storage, the left‑most prefix rule, monotonic primary keys, int display length, SHOW INDEX fields, handling LIKE patterns, and efficient pagination techniques.

SQLdatabaseindexes
0 likes · 14 min read
Master MySQL: Key Differences, Index Types, and Performance Tips
ITPUB
ITPUB
Mar 16, 2020 · Databases

MySQL Essentials: UNION vs UNION ALL, TRUNCATE vs DELETE, Index Types Explained

This article explains core MySQL concepts, comparing UNION and UNION ALL, TRUNCATE versus DELETE, TIMESTAMP and DATETIME, composite and covering indexes, the left‑most prefix rule, clustered vs non‑clustered indexes, prefix indexes, InnoDB vs MyISAM storage, monotonic primary keys, column length display, SHOW INDEX fields, LIKE pattern pitfalls, and efficient pagination techniques.

SQLdatabaseindexes
0 likes · 15 min read
MySQL Essentials: UNION vs UNION ALL, TRUNCATE vs DELETE, Index Types Explained
Liangxu Linux
Liangxu Linux
Mar 15, 2020 · Databases

Master MySQL Indexes: Differences, Composite Strategies & Performance Hacks

This guide explains essential MySQL concepts such as the distinction between UNION and UNION ALL, TRUNCATE versus DELETE, TIMESTAMP versus DATETIME, the purpose and benefits of composite indexes, index storage engines, prefix indexes, covering indexes, the left‑most prefix rule, and efficient pagination techniques.

SQLdatabaseindexes
0 likes · 15 min read
Master MySQL Indexes: Differences, Composite Strategies & Performance Hacks