BestHub
Sign in
Tagged articles
76 articles
Page 1 of 1
dbaplus Community
dbaplus Community
Mar 4, 2026 · Databases

Master PostgreSQL Execution Plans to Supercharge Your SQL Performance

This guide explains what PostgreSQL execution plans are, how they are generated, and how to interpret them using EXPLAIN and EXPLAIN ANALYZE, then demonstrates three real‑world case studies that show step‑by‑step optimizations with indexes, configuration tweaks, and query rewrites to dramatically improve query speed.

Database PerformanceSQL Optimizationexecution plan
0 likes · 16 min read
Master PostgreSQL Execution Plans to Supercharge Your SQL Performance
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jan 28, 2026 · Databases

Master MySQL EXPLAIN: Decode Execution Plans with Real Examples

This guide introduces MySQL's EXPLAIN command, demonstrates how to create sample order and customer tables, runs various queries, and provides a detailed walkthrough of each column in the execution plan—including id, select_type, table, type, possible_keys, key, key_len, ref, rows, filtered, and extra—plus indexing tips and visual examples.

Database Optimizationexecution planexplain
0 likes · 7 min read
Master MySQL EXPLAIN: Decode Execution Plans with Real Examples
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 29, 2025 · Databases

Why Does the Same SQL Run Faster on Oracle Than on OceanBase? Uncovering Execution Plan Discrepancies

A customer observed a SQL statement that runs twice as fast on Oracle as on OceanBase, prompting a detailed analysis of execution plans, leader distribution, and distributed query behavior, followed by practical hint and table‑group optimizations that reduce the runtime from several seconds to sub‑second levels.

OceanBaseSQL OptimizationTable Group
0 likes · 18 min read
Why Does the Same SQL Run Faster on Oracle Than on OceanBase? Uncovering Execution Plan Discrepancies
Code Mala Tang
Code Mala Tang
Oct 26, 2025 · Databases

Why Parameterized Queries Supercharge SQL Performance (And Prevent Injection)

This article explains how using bound (parameterized) queries in SQL Server improves performance by enabling execution plan reuse, reducing compilation overhead and memory usage, while also preventing SQL injection, and discusses potential pitfalls like parameter sniffing and how to mitigate them with OPTION (RECOMPILE).

Parameterized QueriesSQL injectionexecution plan
0 likes · 6 min read
Why Parameterized Queries Supercharge SQL Performance (And Prevent Injection)
macrozheng
macrozheng
Aug 7, 2025 · Databases

Boost MySQL Performance: 8 Proven SQL Optimization Techniques

This article explores eight common MySQL performance pitfalls—from inefficient LIMIT clauses and implicit type conversions to suboptimal JOIN updates, mixed sorting, EXISTS usage, condition pushdown, early result limiting, and intermediate result set handling—offering rewritten queries and execution plan analyses that dramatically improve execution times.

Database IndexesQuery RewriteSQL Optimization
0 likes · 13 min read
Boost MySQL Performance: 8 Proven SQL Optimization Techniques
ITPUB
ITPUB
Jun 28, 2025 · Databases

How Oracle Executes a SQL Statement: From Parsing to Optimizer

This article explains Oracle's step‑by‑step processing of a SQL statement—including the client submission, parsing checks, optimizer decision‑making, row‑source generation, and final execution—while illustrating hard and soft parses, optimizer components, and practical query‑plan queries.

Oracledatabaseexecution plan
0 likes · 25 min read
How Oracle Executes a SQL Statement: From Parsing to Optimizer
Tech Freedom Circle
Tech Freedom Circle
Jun 6, 2025 · Databases

How to Design the Optimal Index for a 27‑Column Table Query (Alibaba Interview)

This article analyzes a typical Alibaba interview question that asks for the best index on a table with 27 columns for the query SELECT a, b, c FROM table WHERE d = X ORDER BY e, covering index design, field ordering, comparisons with alternative indexes, index condition pushdown, and the detailed MySQL execution process.

covering indexexecution planindex condition pushdown
0 likes · 28 min read
How to Design the Optimal Index for a 27‑Column Table Query (Alibaba Interview)
Aikesheng Open Source Community
Aikesheng Open Source Community
May 28, 2025 · Databases

Analyzing and Optimizing Slow OceanBase SQL Queries Using TopSQL and Execution Plan Rewrites

This article investigates a slow OceanBase SQL query by examining CPU and TopSQL metrics, dissecting the execution plan, identifying batch join inefficiencies, rewriting the SQL for better performance, and demonstrating a reduction in execution time from over 2600 seconds to under one second.

Batch JoinDatabase PerformanceOceanBase
0 likes · 18 min read
Analyzing and Optimizing Slow OceanBase SQL Queries Using TopSQL and Execution Plan Rewrites
Aikesheng Open Source Community
Aikesheng Open Source Community
May 27, 2025 · Databases

MySQL Execution Plans in Tree Format

This article introduces MySQL's tree‑style execution plan output using EXPLAIN FORMAT=TREE, explains its advantages over traditional and JSON formats, and demonstrates its practical use through eight detailed SQL examples with full plan analysis and performance insights.

SQL OptimizationTree Formatdatabase
0 likes · 12 min read
MySQL Execution Plans in Tree Format
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.

MVCCbuffer poolexecution plan
0 likes · 19 min read
Understanding MySQL Index Structures, Execution Plans, Transactions, and MVCC
Alibaba Cloud Developer
Alibaba Cloud Developer
Jan 11, 2024 · Big Data

Unlock ODPS SQL Performance: Deep Dive into Execution Plans & Optimizations

This article examines ODPS SQL performance by dissecting logical execution plans and Logview visualizations, explaining the underlying principles of various optimization techniques such as multi‑distinct handling, shuffle reduction, system parameters, and different join strategies, and demonstrates how to apply these methods to improve query efficiency in real‑world data engineering tasks.

ODPSShuffleexecution plan
0 likes · 17 min read
Unlock ODPS SQL Performance: Deep Dive into Execution Plans & Optimizations
dbaplus Community
dbaplus Community
Nov 13, 2023 · Databases

How a MySQL CPU Spike Exposed Critical Query Mis‑optimizations

An urgent overnight incident revealed a MySQL server’s CPU soaring to 400% due to poorly written queries, prompting a detailed analysis of execution plans, identification of costly operations like filesort and temporary tables, and concrete recommendations for query and team improvements.

Backenddatabaseexecution plan
0 likes · 8 min read
How a MySQL CPU Spike Exposed Critical Query Mis‑optimizations
Laravel Tech Community
Laravel Tech Community
Aug 28, 2023 · Databases

Common MySQL Performance Issues and Their Optimization Techniques

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, early range reduction, and intermediate result handling, and provides concrete SQL rewrites and execution‑plan analyses to dramatically improve query speed.

Query Rewriteexecution planindexing
0 likes · 13 min read
Common MySQL Performance Issues and Their Optimization Techniques
ITPUB
ITPUB
Mar 12, 2023 · Databases

Master Real-World SQL Optimization: From Identifying Slow Queries to 20× Speed Boost

This article walks through a practical SQL optimization workflow, showing how to detect problematic queries via system metrics and execution plans, analyze table structures and indexes, apply concrete ALTER statements and index changes, and iteratively verify performance improvements, illustrated with a detailed MySQL case study that achieved a twenty‑fold speed increase.

Index Optimizationexecution planmysql
0 likes · 10 min read
Master Real-World SQL Optimization: From Identifying Slow Queries to 20× Speed Boost
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 13, 2023 · Databases

Why the Same SQL Has Different Execution Plans in QA and DEV Environments and How to Optimize It

The article analyzes why an identical MySQL query runs faster in a QA environment than in DEV, examines execution‑plan differences caused by table driving choices, optimizer settings, and unnecessary conditions, and demonstrates how rewriting the SQL and adjusting hints can achieve a stable, efficient plan.

Database PerformanceSQL Optimizationexecution plan
0 likes · 17 min read
Why the Same SQL Has Different Execution Plans in QA and DEV Environments and How to Optimize It
JD Cloud Developers
JD Cloud Developers
Feb 6, 2023 · Databases

Master MySQL Performance: Indexing, Execution Plans, and Real-World Cases

This article explains why database performance monitoring becomes critical as data grows, outlines common optimization techniques, dives into MySQL's storage architecture and index structures, and shares three real‑world cases that illustrate how proper indexing and execution‑plan analysis can prevent severe latency and CPU spikes.

Database PerformanceIndex OptimizationSQL Tuning
0 likes · 15 min read
Master MySQL Performance: Indexing, Execution Plans, and Real-World Cases
dbaplus Community
dbaplus Community
Nov 19, 2022 · Databases

How to Speed Up MySQL Queries: Indexing and Execution Plan Optimization

This article walks through a MySQL performance case study, showing how nested subqueries on large tables can take hours, and demonstrates step‑by‑step how creating single‑column, composite, and covering indexes, as well as rewriting queries as joins, reduces execution time from tens of thousands of seconds to milliseconds.

execution planindexingmysql
0 likes · 12 min read
How to Speed Up MySQL Queries: Indexing and Execution Plan Optimization
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.

SQL Optimizationdatabaseexecution plan
0 likes · 14 min read
Master MySQL Execution Order: 8 Proven Techniques to Supercharge Query Performance
dbaplus Community
dbaplus Community
Sep 22, 2022 · Databases

Why MySQL IN Subqueries Turn Into Slow Full Scans—and How to Fix Them

A large‑scale user‑push system suffers from minutes‑long MySQL queries because the IN subquery materializes a temporary table and triggers a semi‑join that forces full table scans, but disabling the semi‑join optimizer or rewriting the query restores sub‑second performance.

SQL OptimizationSemi-Joinexecution plan
0 likes · 8 min read
Why MySQL IN Subqueries Turn Into Slow Full Scans—and How to Fix Them
dbaplus Community
dbaplus Community
Aug 11, 2022 · Databases

5 Essential Rules for Writing High‑Performance SQL Queries

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

Subqueriesdatabasesexecution plan
0 likes · 13 min read
5 Essential Rules for Writing High‑Performance SQL Queries
Java High-Performance Architecture
Java High-Performance Architecture
Aug 2, 2022 · Databases

Why MySQL IN Subqueries Can Be So Slow and How to Fix Them

This article examines why a MySQL query that uses an IN subquery on a massive users table becomes extremely slow, analyzes the execution plan revealing materialized temporary tables and semi‑join optimization, and demonstrates how disabling the optimizer or rewriting the query restores index usage and dramatically improves performance.

Semi-Joinexecution planindexing
0 likes · 8 min read
Why MySQL IN Subqueries Can Be So Slow and How to Fix Them
Architecture Digest
Architecture Digest
Jul 18, 2022 · Databases

Why MySQL IN Subquery with Semi‑Join Is Slow and How to Optimize It

The article analyzes a slow MySQL query that uses an IN subquery on a massive user table, explains how the optimizer’s semi‑join and materialized temporary tables cause full‑table scans, and demonstrates practical fixes such as disabling the semi‑join optimizer switch or rewriting the SQL to regain index usage.

SQL OptimizationSemi-Joinexecution plan
0 likes · 8 min read
Why MySQL IN Subquery with Semi‑Join Is Slow and How to Optimize It
ITPUB
ITPUB
Mar 8, 2022 · Databases

Mastering PostgreSQL Execution Plans: From Basics to Advanced Optimization

This article explains how PostgreSQL generates execution plans, details the plan tree structure, cost parameters, scan and join methods, and provides practical tips for using EXPLAIN, tuning planner settings, and applying hints to optimize SQL performance.

Join Typescost estimationexecution plan
0 likes · 17 min read
Mastering PostgreSQL Execution Plans: From Basics to Advanced Optimization
dbaplus Community
dbaplus Community
Jan 3, 2022 · Databases

What Happens When a Single Bad SQL Slows Down an Entire Data Warehouse? Real Cases & Fixes

This article presents four real‑world Oracle SQL cases—from a Cartesian join that halted nightly reports to a varchar primary key causing full scans, non‑standard date syntax breaking partition pruning, and missing statistics leading to unstable plans—detailing analysis, execution‑plan insights, and concrete remediation steps.

OracleSQL Optimizationexecution plan
0 likes · 19 min read
What Happens When a Single Bad SQL Slows Down an Entire Data Warehouse? Real Cases & Fixes
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
Laravel Tech Community
Laravel Tech Community
Apr 28, 2021 · Databases

Understanding and Analyzing MySQL Execution Plans

This article explains the three‑layer architecture of MySQL, how an execution plan is generated and interpreted, and provides a detailed walkthrough of the columns displayed by the EXPLAIN statement to help developers optimize their SQL queries.

databaseexecution planexplain
0 likes · 8 min read
Understanding and Analyzing MySQL Execution Plans
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 9, 2021 · Databases

Optimizing DBLE Distributed Database Middleware: Cases of Query Push‑Down Failures and Their Solutions

This article analyzes why certain join queries in DBLE distributed database middleware fail to push down to backend nodes, leading to high CPU usage and latency, and presents four concrete examples with step‑by‑step optimizations to ensure full query push‑down and improved performance.

DBLESQL pushdowndistributed database
0 likes · 8 min read
Optimizing DBLE Distributed Database Middleware: Cases of Query Push‑Down Failures and Their Solutions
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 2, 2021 · Databases

Overview of MySQL Execution Plan Fields

This article explains the meaning of each column in MySQL's EXPLAIN output, including id, select_type, type, possible_keys, key, key_len, ref, rows, filtered, and Extra, with examples of various query patterns such as simple selects, joins, subqueries, UNIONs, and derived tables.

execution planexplainmysql
0 likes · 22 min read
Overview of MySQL Execution Plan Fields
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
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.

execution planindexespagination
0 likes · 14 min read
5 Essential Rules for Writing High‑Performance SQL Queries
Programmer DD
Programmer DD
Oct 23, 2020 · Databases

Master MySQL EXPLAIN: Decode Execution Plans and Optimize Queries

This guide walks you through MySQL's EXPLAIN command, explaining each output column, demonstrating how to read execution plans for simple selects, joins, subqueries, UNIONs, and advanced variants, and showing how to use this information to improve query performance.

execution planexplainmysql
0 likes · 24 min read
Master MySQL EXPLAIN: Decode Execution Plans and Optimize Queries
Big Data Technology & Architecture
Big Data Technology & Architecture
Jun 7, 2020 · Big Data

A Unified View of SQL‑on‑Hadoop Systems: Architecture, Execution Plans, Optimizations, and Storage Formats

The article provides a comprehensive overview of SQL‑on‑Hadoop query engines such as Hive, Impala, Presto and Spark SQL, comparing their runtime frameworks, core components, compilation steps, optimizer strategies, CPU/IO efficiency techniques, storage formats like ORC and Parquet, and resource management in a unified perspective.

Big DataQuery EngineSQL on Hadoop
0 likes · 24 min read
A Unified View of SQL‑on‑Hadoop Systems: Architecture, Execution Plans, Optimizations, and Storage Formats
ITPUB
ITPUB
May 30, 2020 · Databases

Master Oracle SQL Performance: 40 Proven Optimization Techniques

This guide walks through Oracle SQL execution steps, optimizer choices, indexing strategies, query rewrites, hint usage, and practical code examples to help developers dramatically improve query performance and reduce database workload.

HintsOracleexecution plan
0 likes · 20 min read
Master Oracle SQL Performance: 40 Proven Optimization Techniques
Efficient Ops
Efficient Ops
Feb 9, 2020 · Databases

Why a MySQL Query Took 30 Seconds and How a Hidden Index Cut It to 0.2 s

A production MySQL query on a table with five million rows took over 30 seconds, and after reproducing the issue, examining execution plans, trying various index and query tweaks, discovering that SQLyog adds a hidden LIMIT, and finally forcing the correct index, the runtime dropped to under a second, illustrating the importance of proper index usage and tool‑specific quirks.

Index OptimizationSQLyogexecution plan
0 likes · 6 min read
Why a MySQL Query Took 30 Seconds and How a Hidden Index Cut It to 0.2 s
Java Captain
Java Captain
Jan 26, 2020 · 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 run a GROUP BY query, explores several ineffective optimization attempts, reveals a client‑side limit issue, and finally solves the problem by forcing the correct index, cutting the runtime to under 0.2 seconds.

Index Optimizationdistinct vs group byexecution plan
0 likes · 5 min read
MySQL Slow Query Optimization: Reducing Execution Time from 30 Seconds to 0.19 Seconds
IT Architects Alliance
IT Architects Alliance
Nov 21, 2019 · Databases

Why MySQL Subqueries Took Hours and How Indexes Fixed It

A MySQL 5.6 database with three large tables suffered a 30,000‑second query when searching for students scoring 100 in a specific subject; by analyzing the execution plan, adding indexes on filter columns, and rewriting the query as a join, execution time dropped to under a second.

JOINSQL OptimizationSubquery
0 likes · 8 min read
Why MySQL Subqueries Took Hours and How Indexes Fixed It
ITPUB
ITPUB
Jul 17, 2019 · Databases

How to Decode MySQL Execution Plans for Faster Queries

This article explains how to use MySQL's EXPLAIN and EXPLAIN EXTENDED commands to analyze query execution plans, interpret each column such as id, select_type, type, and extra, and apply practical optimization techniques like indexing, avoiding full‑table scans, and forcing index usage to improve SQL performance.

SQL Optimizationexecution planindexes
0 likes · 12 min read
How to Decode MySQL Execution Plans for Faster Queries
Java Captain
Java Captain
Mar 29, 2019 · Databases

MySQL Query Optimization: Indexing Strategies and Execution Plan Analysis

This article demonstrates how to dramatically improve MySQL query performance by analyzing execution plans, adding appropriate single‑column and composite indexes, converting subqueries to EXISTS or JOINs, and leveraging index coverage and ordering, with detailed examples and timing results.

Index OptimizationSQL Tuningexecution plan
0 likes · 12 min read
MySQL Query Optimization: Indexing Strategies and Execution Plan Analysis
ITPUB
ITPUB
Apr 12, 2018 · Databases

When Does SQL Server Auto‑Parameterize and How to Prevent Bad Execution Plans?

This article explains SQL Server's simple and forced parameterization modes, shows when automatic parameterization occurs, illustrates the pitfalls such as parameter sniffing with concrete examples, and provides a practical fix using the OPTION(RECOMPILE) hint to avoid incorrect plan reuse.

SQL Serverauto-parameterizationexecution plan
0 likes · 8 min read
When Does SQL Server Auto‑Parameterize and How to Prevent Bad Execution Plans?
ITPUB
ITPUB
Aug 30, 2017 · Databases

How to Slash SQL I/O and CPU Costs: Practical Query Performance Tips

Learn practical techniques to reduce unnecessary I/O and CPU consumption in SQL queries, including narrowing scan ranges, using partition filters, optimizing joins, leveraging hints, bind variables, and proper use of MERGE, UPDATE, EXISTS/IN, pagination, temporary tables, and other performance‑tuning strategies.

Oracleexecution planindexes
0 likes · 8 min read
How to Slash SQL I/O and CPU Costs: Practical Query Performance Tips
dbaplus Community
dbaplus Community
Aug 13, 2017 · Databases

Mastering Oracle Execution Plans: Control, Hints, and Design Tricks

This article teaches how to read and manipulate Oracle execution plans using hints, SQL rewrites, design features, and statistics tricks, providing step‑by‑step examples, common pitfalls, and practical scripts to achieve predictable performance without costly statistics collection.

HintsOracleexecution plan
0 likes · 18 min read
Mastering Oracle Execution Plans: Control, Hints, and Design Tricks
dbaplus Community
dbaplus Community
Jun 26, 2017 · Databases

Turning a 12‑Hour Oracle Query into Minutes: Proven SQL Tuning Techniques

This article walks through a real‑world Oracle SQL tuning case, showing how to dissect a 12‑hour execution plan, fix cardinality and statistics issues, eliminate costly Filter operations, rewrite queries for efficient HASH JOINs, and leverage tools like 10053 and SQLT to dramatically improve performance.

Oracleexecution planstatistics
0 likes · 23 min read
Turning a 12‑Hour Oracle Query into Minutes: Proven SQL Tuning Techniques
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
Qunar Tech Salon
Qunar Tech Salon
May 18, 2017 · Databases

Understanding Bind Variable Peeking and Its Impact on Oracle Execution Plans

This article explains how Oracle's bind variable peeking influences execution plan selection, demonstrates the performance differences between full table scans and index scans with skewed data distributions, and provides practical methods—including 10046 events, v$sql_bind_capture, and AWR views—to capture and analyze bind variable values for better SQL tuning.

AWRBind VariablesOracle
0 likes · 14 min read
Understanding Bind Variable Peeking and Its Impact on Oracle Execution Plans
dbaplus Community
dbaplus Community
Mar 28, 2017 · Databases

Why an Oracle SQL Slowed After Upgrade—and How to Fix It

After migrating a core system from AIX to Linux and upgrading Oracle from 11.2.0.3 to 11.2.0.4, a critical SQL that previously ran in milliseconds began taking hundreds of seconds, prompting a detailed investigation of execution plans, CBO limitations, and three successive rewrite strategies that restored performance.

CBOOracleSQL Optimization
0 likes · 9 min read
Why an Oracle SQL Slowed After Upgrade—and How to Fix It
ITPUB
ITPUB
Mar 10, 2017 · Databases

Master SQL Server Query Execution: Order, Tips, and Real-World Optimizations

This article explains SQL Server's logical and physical query execution order, offers practical techniques such as converting loops to batch operations, using temporary tables, optimizing indexes, and avoiding common pitfalls, all illustrated with code samples and performance measurements.

SQL ServerTemp Tablesexecution plan
0 likes · 15 min read
Master SQL Server Query Execution: Order, Tips, and Real-World Optimizations
dbaplus Community
dbaplus Community
Feb 20, 2017 · Databases

How I Slashed an Oracle SQL Query from 11 s to 1.8 s Under a Tight Release Freeze

Facing a tight September release deadline, the author tackled two critical Oracle SQL performance issues by analyzing execution plans, replacing a costly view, applying driver‑table hints, removing unnecessary CASTs and a random‑number function, ultimately cutting query time from 11 seconds to under 2 seconds.

Database OptimizationOracleexecution plan
0 likes · 12 min read
How I Slashed an Oracle SQL Query from 11 s to 1.8 s Under a Tight Release Freeze
dbaplus Community
dbaplus Community
Jan 10, 2017 · Databases

How I Fixed a Sudden Oracle SQL Slowdown by Binding Execution Plans (And What Went Wrong)

When a critical Oracle query suddenly slowed down on regional databases while the central server remained fast, I diagnosed the issue, discovered execution‑plan differences caused by missing predicate push‑down, attempted a plan‑binding solution, faced unexpected failures, and ultimately rewrote the SQL using a WITH clause to meet a tight deadline.

Database PerformanceOraclePredicate Pushdown
0 likes · 11 min read
How I Fixed a Sudden Oracle SQL Slowdown by Binding Execution Plans (And What Went Wrong)
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Dec 24, 2016 · Databases

Why Your SQL Execution Plans Fail and How to Optimize Them

This article explains what execution plans are, why seemingly identical SQL statements can produce different plans, and offers practical tips—such as standardizing query syntax, simplifying nested queries, using temporary tables, bind variables, appropriate transaction scopes, and careful use of NOLOCK—to improve database performance and avoid common pitfalls.

Bind VariablesDatabase OptimizationSQL Server
0 likes · 13 min read
Why Your SQL Execution Plans Fail and How to Optimize Them
dbaplus Community
dbaplus Community
Nov 10, 2016 · Databases

Doubling SQL Speed: From Execution Plans to Business Logic Overhaul

A real‑world case study shows how a seemingly simple intersect query that took 20 seconds was optimized to 10 seconds by analyzing execution plans, rewriting the SQL, exploring parallel execution, and ultimately redesigning the business logic with a new timestamp column to enable incremental checks.

business logicdatabaseexecution plan
0 likes · 10 min read
Doubling SQL Speed: From Execution Plans to Business Logic Overhaul
ITPUB
ITPUB
Sep 12, 2016 · Databases

Why Oracle’s Optimizer Misestimates Multi‑Column Filters and How to Fix It

This article explains how Oracle’s Cost‑Based Optimizer can produce incorrect row estimates for queries with multiple column predicates, demonstrates the problem with a test table, and shows that gathering multi‑column statistics resolves the misestimation, improving execution plans.

Multi-Column StatisticsOracleQuery Optimizer
0 likes · 8 min read
Why Oracle’s Optimizer Misestimates Multi‑Column Filters and How to Fix It
dbaplus Community
dbaplus Community
Aug 15, 2016 · Databases

Unlocking SQL: Why It Remains the Key to Databases and How to Optimize It

This comprehensive presentation explores SQL’s history, its enduring relevance amid NoSQL and NewSQL trends, explains the execution order and optimizer mechanics, offers practical optimization rules and step‑by‑step execution processes, and illustrates concepts through multiple real‑world case studies and a detailed Q&A.

Case StudiesDatabase OptimizationQuery Optimizer
0 likes · 23 min read
Unlocking SQL: Why It Remains the Key to Databases and How to Optimize It
dbaplus Community
dbaplus Community
May 15, 2016 · Databases

Unlocking SQL Server Parallel Query Execution: Concepts, Plans, and Practical Tips

SQL Server’s parallel query execution leverages multiple CPUs to accelerate CPU‑bound workloads, and this article explains the underlying hardware prerequisites, scheduler/task/worker model, serial vs parallel plans, exchange operators, parallel joins, CXPACKET waits, and configuration settings such as cost threshold and max degree of parallelism.

CXPACKETDatabase PerformanceParallel Joins
0 likes · 15 min read
Unlocking SQL Server Parallel Query Execution: Concepts, Plans, and Practical Tips
ITPUB
ITPUB
May 3, 2016 · Databases

Practical Tips for Optimizing Oracle SQL Execution Plans

This guide outlines concrete strategies to reduce I/O and CPU overhead in Oracle queries, covering scope reduction, partition pruning, join simplification, hint usage, bind variables, and common pitfalls like Cartesian products and inefficient filters.

Database OptimizationJoinsOracle
0 likes · 8 min read
Practical Tips for Optimizing Oracle SQL Execution Plans