BestHub
Sign in
Tagged articles
56 articles
Page 1 of 1
Java Tech Enthusiast
Java Tech Enthusiast
Mar 13, 2026 · Databases

When Does SELECT * Break Your MySQL Index? A Deep Dive into Index Invalidation

This article explains why using SELECT * does not automatically invalidate MySQL indexes, explores common scenarios that cause index loss such as left‑most prefix violations, function calls, implicit type conversions, wildcard LIKE patterns, OR/IN/NOT IN misuse, and ORDER BY pitfalls, and provides practical optimization recommendations with concrete SQL examples and verification methods.

Query TuningSQLdatabase
0 likes · 14 min read
When Does SELECT * Break Your MySQL Index? A Deep Dive into Index Invalidation
Su San Talks Tech
Su San Talks Tech
Jun 30, 2025 · Databases

10 Proven Index Design Rules to Supercharge Database Performance

This article presents ten practical rules for designing database indexes—covering business‑scenario analysis, the left‑most prefix principle, avoiding over‑indexing, using covering indexes, data‑type choices, function traps, prefix indexes, NULL handling, maintenance scripts, and monitoring—each illustrated with SQL examples, diagrams, and real‑world performance gains.

Performance OptimizationQuery TuningSQL
0 likes · 13 min read
10 Proven Index Design Rules to Supercharge Database Performance
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.

Performance OptimizationQuery TuningSQL
0 likes · 10 min read
10 Powerful SQL Optimization Techniques to Boost Query Performance
Mingyi World Elasticsearch
Mingyi World Elasticsearch
Feb 11, 2025 · Backend Development

10 Powerful Elasticsearch DSL Tricks to Solve Real‑World Performance Pain Points

This article presents ten practical Elasticsearch performance‑tuning techniques—including query DSL, deep pagination, mapping design, high‑cardinality aggregations, nested queries, script optimization, index templates, force‑merge, bulk writes, and profiling—each illustrated with concrete scenarios, code snippets, and step‑by‑step analysis to boost cluster speed and stability.

Bulk WriteDSLElasticsearch
0 likes · 12 min read
10 Powerful Elasticsearch DSL Tricks to Solve Real‑World Performance Pain Points
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
Liangxu Linux
Liangxu Linux
Jun 11, 2024 · Databases

Boost MySQL Performance: Master LIMIT, Implicit Conversion, JOIN Updates, and More

This article explains common MySQL performance pitfalls such as inefficient LIMIT pagination, implicit type conversion, sub‑query‑based updates, mixed ordering, misuse of EXISTS, and condition push‑down, and provides concrete rewrites and examples that reduce query times from seconds to milliseconds.

Query TuningSQL Optimizationmysql
0 likes · 13 min read
Boost MySQL Performance: Master LIMIT, Implicit Conversion, JOIN Updates, and More
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.

Query TuningSQLrefactoring
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.

Database PerformanceIndex OptimizationQuery Tuning
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 OptimizationQuery TuningSQL
0 likes · 28 min read
30 Proven SQL Optimization Tips to Boost Query Performance
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Apr 8, 2024 · Databases

9 Essential MySQL Index Optimization Techniques You Must Know

This article presents nine practical MySQL index optimization techniques—from selecting high‑selectivity columns and avoiding functions on indexed fields to applying the leftmost‑prefix rule, handling NULLs, using proper LIKE patterns, and leveraging EXPLAIN and LIMIT 1 for faster queries.

Database PerformanceIndex OptimizationQuery Tuning
0 likes · 6 min read
9 Essential MySQL Index Optimization Techniques You Must Know
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.

Query Tuning
0 likes · 14 min read
Boost MySQL Performance: 8 Proven Query Optimization Techniques
ITPUB
ITPUB
Jan 3, 2024 · Databases

Why MySQL Queries Can Be 50,000× Faster with Proper Indexing

This article walks through a MySQL 5.6 scenario where a sub‑query that scans 700,000 rows takes over 30,000 seconds, then demonstrates how adding single‑column and composite indexes, rewriting the query as a join, and analyzing execution plans reduces the runtime to milliseconds, highlighting best‑practice indexing techniques.

Index OptimizationQuery TuningSQL Performance
0 likes · 12 min read
Why MySQL Queries Can Be 50,000× Faster with Proper Indexing
dbaplus Community
dbaplus Community
Dec 27, 2023 · Backend Development

Boost Elasticsearch Performance: 24 Proven Tips and Pitfalls to Avoid

This article compiles practical Elasticsearch recommendations—covering query caching, aggregation design, pagination strategies, scripting, mapping choices, shard and replica settings, and bulk indexing—to help engineers write faster, more reliable search queries while avoiding common performance traps.

Performance OptimizationQuery TuningSearch
0 likes · 26 min read
Boost Elasticsearch Performance: 24 Proven Tips and Pitfalls to Avoid
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.

Database PerformanceQuery TuningSQL Optimization
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.

Database PerformanceIndex OptimizationQuery 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.

Database PerformanceQuery TuningSQL Optimization
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.

Composite IndexDatabase PerformanceQuery 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.

Query TuningSQLdatabase
0 likes · 14 min read
8 Common SQL Pitfalls and How to Optimize Them for Lightning‑Fast Queries
ITPUB
ITPUB
Feb 28, 2023 · Databases

Master MySQL Query Performance: A Step‑by‑Step SQL Optimization Guide

This article explains how to prepare and tune MySQL SQL statements before execution, covering logical and physical optimization, table and view analysis, join‑key checks, query rewriting, and execution‑plan evaluation to achieve faster, more efficient database queries.

Database PerformanceQuery TuningSQL Optimization
0 likes · 9 min read
Master MySQL Query Performance: A Step‑by‑Step SQL Optimization Guide
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.

Database PerformanceQuery TuningSQL Optimization
0 likes · 8 min read
SQL Statement Optimization Practices for MySQL
Programmer DD
Programmer DD
Oct 26, 2022 · Databases

Boost MySQL Performance: 20 Proven SQL Optimization Tips

This article presents a comprehensive set of MySQL optimization techniques, covering everything from avoiding SELECT * and OR conditions to proper index usage, join strategies, batch operations, and query planning, all aimed at reducing resource consumption, improving execution speed, and ensuring reliable database design.

Database PerformanceQuery TuningSQL Optimization
0 likes · 19 min read
Boost MySQL Performance: 20 Proven SQL Optimization Tips
dbaplus Community
dbaplus Community
Aug 21, 2022 · Databases

Master MySQL Performance: Architecture, Indexes, and Advanced Query Tuning

This comprehensive guide walks you through MySQL's core architecture, explains why SQL optimization matters, details index types and creation methods, demystifies EXPLAIN output, and provides practical examples and best‑practice tips to dramatically improve query performance.

Database PerformanceExplain PlanQuery Tuning
0 likes · 34 min read
Master MySQL Performance: Architecture, Indexes, and Advanced Query Tuning
dbaplus Community
dbaplus Community
Aug 14, 2022 · Databases

Master MySQL Performance: 12 Proven SQL Optimization Techniques

This article explains MySQL's internal architecture and provides twelve practical SQL optimization strategies—including avoiding subqueries, using IN instead of OR, efficient pagination, minimizing ORDER BY, batch inserts, selective column retrieval, proper JOIN handling, and index best practices—to dramatically improve database query performance.

Database PerformanceQuery TuningSQL Optimization
0 likes · 20 min read
Master MySQL Performance: 12 Proven SQL Optimization Techniques
Open Source Linux
Open Source Linux
Apr 19, 2022 · Databases

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

This article examines frequent SQL anti‑patterns—such as inefficient LIMIT usage, implicit type conversion, suboptimal UPDATE/DELETE joins, mixed ordering, unnecessary EXISTS clauses, condition push‑down failures, early limiting, and intermediate result handling—and provides rewritten queries that dramatically improve performance.

Performance OptimizationQuery TuningSQL
0 likes · 14 min read
8 Common SQL Pitfalls and How to Optimize Them for Faster Queries
Big Data Technology & Architecture
Big Data Technology & Architecture
Apr 13, 2022 · Databases

Common MySQL Index Failure Scenarios and Optimization Techniques

This article explains typical MySQL index failure cases such as left‑most matching truncation, implicit conversion, IN + ORDER BY, range queries, leading wildcard, OR conditions, function usage, NOT IN/!=, low selectivity, and index fragmentation, and provides practical optimization strategies including index redesign, covering indexes, and pagination improvements.

Database PerformanceIndex OptimizationQuery Tuning
0 likes · 17 min read
Common MySQL Index Failure Scenarios and Optimization Techniques
dbaplus Community
dbaplus Community
Dec 12, 2021 · Databases

7 Common MySQL Index Pitfalls That Can Kill Query Performance

This article examines seven typical scenarios where MySQL indexes unexpectedly fail—such as OR conditions, leading wildcards in LIKE, missing quotes, functions on indexed columns, NULL checks, arithmetic operations, and composite index ordering—providing SQL examples, execution plans, and practical tips to avoid costly full‑table scans.

Database OptimizationQuery TuningSQL
0 likes · 9 min read
7 Common MySQL Index Pitfalls That Can Kill 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.

Query TuningSQLdatabase
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 OptimizationQuery TuningTransactions
0 likes · 14 min read
MySQL Optimization: Concepts, Schema Design, Indexes, and Query Tuning
Su San Talks Tech
Su San Talks Tech
Nov 10, 2021 · Databases

15 Proven SQL Optimization Techniques to Boost Query Performance

This article presents fifteen practical SQL optimization tips—including avoiding SELECT *, using UNION ALL, driving large tables with small ones, batch operations, LIMIT usage, index control, proper data types, and efficient GROUP BY—to help developers improve query speed, reduce resource consumption, and avoid common performance pitfalls.

Query TuningSQLdatabase
0 likes · 20 min read
15 Proven SQL Optimization Techniques to Boost Query Performance
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
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
Code Ape Tech Column
Code Ape Tech Column
Jun 4, 2021 · Databases

8 MySQL Performance Tricks to Slash Query Time from Seconds to Milliseconds

This article examines common MySQL performance pitfalls such as inefficient LIMIT offsets, implicit type conversions, suboptimal UPDATE/DELETE joins, mixed sorting, misuse of EXISTS, and limited condition pushdown, then demonstrates concrete rewrites—including range reduction and WITH clauses—that reduce execution times from seconds to milliseconds.

Performance OptimizationQuery TuningSQL
0 likes · 12 min read
8 MySQL Performance Tricks to Slash Query Time from Seconds to Milliseconds
ITPUB
ITPUB
Feb 18, 2021 · Databases

52 Proven SQL Performance Optimization Techniques to Supercharge Your Queries

This article compiles fifty‑two practical SQL tuning strategies—including proper indexing, query rewriting, avoiding full table scans, using temporary tables, managing locks, and choosing the right storage engine—to help developers dramatically improve database query performance and scalability.

Query TuningSQLindexing
0 likes · 22 min read
52 Proven SQL Performance Optimization Techniques to Supercharge Your Queries
Code Ape Tech Column
Code Ape Tech Column
Feb 16, 2021 · Databases

52 Proven SQL Optimization Techniques to Supercharge Your Queries

This article compiles 52 practical SQL performance‑tuning strategies—including indexing rules, query‑writing shortcuts, join optimizations, lock handling, temporary tables, storage‑engine choices, data‑type recommendations, backup tips, and useful code examples—to help developers dramatically improve query speed and overall database efficiency.

Query TuningSQLdatabase
0 likes · 20 min read
52 Proven SQL Optimization Techniques to Supercharge Your Queries
Programmer DD
Programmer DD
Dec 4, 2020 · Databases

Boost MySQL Performance: 8 Common SQL Pitfalls and How to Fix Them

This article examines frequent MySQL performance problems such as inefficient LIMIT usage, implicit type conversion, sub‑query updates, mixed sorting, EXISTS clauses, condition push‑down, pre‑filtering, and intermediate result handling, and provides rewritten SQL examples that dramatically reduce execution time.

Database PerformanceQuery TuningSQL Optimization
0 likes · 14 min read
Boost MySQL Performance: 8 Common SQL Pitfalls and How to Fix Them
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.

Database PerformanceIndex OptimizationQuery Tuning
0 likes · 16 min read
20 Principles for MySQL Index Optimization
Code Ape Tech Column
Code Ape Tech Column
Sep 1, 2020 · Databases

Comprehensive Guide to MySQL Database Optimization: SQL Tuning, Index Strategies, and Best Practices

This article presents a thorough overview of MySQL performance tuning, covering step‑by‑step SQL optimization techniques, common pitfalls, index and table‑structure improvements, cache parameter adjustments, and practical guidelines to reduce I/O and CPU bottlenecks while maintaining data integrity.

Database PerformanceQuery TuningSQL Optimization
0 likes · 28 min read
Comprehensive Guide to MySQL Database Optimization: SQL Tuning, Index Strategies, and Best Practices
Code Ape Tech Column
Code Ape Tech Column
Aug 29, 2020 · Databases

20 Essential MySQL Index Optimization Rules Every Developer Should Know

This article outlines twenty practical principles for optimizing MySQL indexes, covering topics such as LIKE wildcards, UNION/IN/OR usage, negative conditions, composite index prefix rules, range queries, function avoidance, covering indexes, prefix indexes, pagination strategies, and common misconceptions, all illustrated with SQL examples and performance tips.

Database PerformanceIndex OptimizationQuery Tuning
0 likes · 16 min read
20 Essential MySQL Index Optimization Rules Every Developer Should Know
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
Programmer DD
Programmer DD
Jan 3, 2020 · Databases

How to Supercharge MySQL Queries: 8 Proven Optimization Techniques

This article explores common MySQL performance pitfalls such as inefficient LIMIT usage, implicit type conversion, subquery handling, and mixed sorting, and demonstrates eight practical rewrite strategies—including index‑friendly pagination, JOIN replacements, condition pushdown, and WITH clauses—to dramatically reduce query execution times from seconds to milliseconds.

Database PerformanceQuery TuningSQL Optimization
0 likes · 8 min read
How to Supercharge MySQL Queries: 8 Proven Optimization Techniques
Java Captain
Java Captain
Oct 11, 2019 · Databases

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

This article introduces MySQL fundamentals, covering logical architecture, locking, transactions, storage engines, schema and data type design, as well as index types and their constraints, plus practical creation‑time and query‑time optimization techniques with code examples and best‑practice recommendations.

Database OptimizationQuery TuningTransactions
0 likes · 11 min read
MySQL Optimization: Concepts, Schema Design, Indexing, and Query Tuning
Liangxu Linux
Liangxu Linux
Aug 27, 2019 · Databases

19 Essential MySQL Optimization Techniques Every Developer Should Know

This guide compiles nineteen practical MySQL optimization tips—from using EXPLAIN and avoiding costly IN clauses to leveraging full‑text indexes, proper pagination, and join strategies—providing concrete SQL examples and actionable advice to improve query performance and reduce resource consumption.

Query TuningSQLindexing
0 likes · 11 min read
19 Essential MySQL Optimization Techniques Every Developer Should Know
Java Captain
Java Captain
Jan 21, 2019 · Databases

19 Common MySQL Optimization Techniques

The article lists nineteen practical MySQL optimization methods—including using EXPLAIN, limiting IN clause size, avoiding SELECT *, using LIMIT 1, reducing unnecessary sorting, preferring UNION ALL, avoiding ORDER BY RAND(), distinguishing IN/EXISTS, applying proper pagination, segment queries, avoiding NULL checks, using full‑text indexes, preventing expression‑based WHERE clauses, respecting left‑most prefix, forcing indexes, handling range queries, and optimizing JOINs—to improve query performance and resource usage.

Query TuningSQLdatabase
0 likes · 11 min read
19 Common MySQL Optimization Techniques
dbaplus Community
dbaplus Community
Jan 1, 2019 · Databases

19 Essential MySQL Optimization Techniques Every Developer Should Know

This article presents 19 practical MySQL optimization tips, ranging from using EXPLAIN and proper indexing to rewriting IN/EXISTS queries, avoiding costly ORDER BY RAND(), improving pagination, leveraging full‑text indexes, and applying join and execution‑plan strategies for faster, more efficient database performance.

Query TuningSQLdatabase
0 likes · 12 min read
19 Essential MySQL Optimization Techniques Every Developer Should Know
ITPUB
ITPUB
Jan 2, 2018 · Databases

10 Proven Techniques to Supercharge Your Database Performance

Learn ten practical strategies to accelerate database queries—including proper schema design, using EXPLAIN, caching, selective column retrieval, LIMIT clauses, avoiding loops, replacing subqueries with joins, careful wildcard use, UNION over OR, and indexing—to reduce server load and improve application responsiveness.

Query TuningSQL Performanceindexing
0 likes · 9 min read
10 Proven Techniques to Supercharge Your Database Performance
Senior Brother's Insights
Senior Brother's Insights
Nov 29, 2017 · Databases

Mastering SQL Performance: Proven Optimization Techniques and Best Practices

Learn a comprehensive methodology for SQL performance tuning, from identifying resource bottlenecks and understanding query processing stages to applying practical optimization tactics such as efficient joins, index usage, avoiding costly operations, and best‑practice guidelines that improve execution speed and resource consumption.

Query TuningSQLdatabase
0 likes · 13 min read
Mastering SQL Performance: Proven Optimization Techniques and Best Practices
dbaplus Community
dbaplus Community
Oct 31, 2017 · Databases

How I Cut a 5‑Second SQL Query to Under 1 Second in a Critical Release

Facing a last‑minute performance crisis on a major release, the author dissected eight SQL statements, merged four permission‑related queries using Oracle's RANK function, and reduced the responsibility‑lookup time from five seconds to under one second, ensuring the system met its strict latency target.

Case StudyOracleQuery Tuning
0 likes · 10 min read
How I Cut a 5‑Second SQL Query to Under 1 Second in a Critical Release
dbaplus Community
dbaplus Community
Jun 11, 2017 · Databases

Mastering Oracle SQL Optimization: Practical Techniques and Real-World Cases

This article compiles a DBAplus online session that presents a systematic SQL‑optimization methodology, rewrite tricks, common pitfalls, and a series of concrete Oracle examples—including CASE WHEN, ROWNUM pagination, hint usage, column selection, function‑call reduction, trigger avoidance, and ROWID access—plus a detailed Q&A that clarifies practical tuning questions.

Database PerformanceOracleQuery Tuning
0 likes · 19 min read
Mastering Oracle SQL Optimization: Practical Techniques and Real-World Cases
ITPUB
ITPUB
Feb 25, 2014 · Databases

Why Database Query Optimization Matters and Key Strategies to Cut Scan Times

The article explains how costly full‑table scans in large databases, such as a bank's million‑record account table, can be reduced to minutes through effective query‑optimization techniques, and outlines the main strategies, automation possibilities, and future trends in SQL performance.

Database OptimizationFull Table ScanQuery Tuning
0 likes · 3 min read
Why Database Query Optimization Matters and Key Strategies to Cut Scan Times