BestHub
Sign in
Tagged articles
407 articles
Page 4 of 5
DataFunTalk
DataFunTalk
Oct 10, 2020 · Product Management

Search Product Optimization: From System Architecture to User Demand and Content Strategies

This article outlines a comprehensive approach for search product managers to drive system improvements, covering overall architecture, query understanding, recall and ranking optimization, business and presentation rules, content enrichment, frontend design, and methods for uncovering user needs through data and behavior analysis.

Searchcontent strategydata analysis
0 likes · 24 min read
Search Product Optimization: From System Architecture to User Demand and Content Strategies
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Oct 2, 2020 · Databases

Essential MySQL Optimization Tips: From EXPLAIN to Advanced Index Strategies

This article presents a comprehensive guide to MySQL performance tuning, covering the use of EXPLAIN, proper handling of IN clauses, selective column queries, limit usage, index best practices, avoiding costly operations, pagination techniques, full‑text search, join optimization, and advanced directives such as FORCE INDEX and STRAIGHT_JOIN.

SQLdatabaseindexing
0 likes · 12 min read
Essential MySQL Optimization Tips: From EXPLAIN to Advanced Index Strategies
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
Programmer DD
Programmer DD
Sep 19, 2020 · Databases

Boost MySQL Pagination Performance: Proven Techniques and Benchmarks

This article examines various MySQL pagination strategies—including simple LIMIT clauses, sub‑query optimizations, ID‑range queries, and temporary‑table methods—by testing them on a table with millions of rows and presenting detailed timing results that reveal significant speed improvements.

LIMITPerformance Testingmysql
0 likes · 9 min read
Boost MySQL Pagination Performance: Proven Techniques and Benchmarks
JavaEdge
JavaEdge
Aug 30, 2020 · Databases

Master MySQL EXPLAIN: Decode Every Column and Boost Query Performance

This guide explains each column returned by MySQL's EXPLAIN output, details join types, possible keys, extra information, and shows how to use EXPLAIN EXTENDED, SHOW PROFILE, and optimizer trace to analyze and optimize SQL queries effectively.

Optimizer_traceSQL profilingexplain
0 likes · 14 min read
Master MySQL EXPLAIN: Decode Every Column and Boost Query Performance
Java Captain
Java Captain
Aug 15, 2020 · Databases

Comprehensive SQL Server Cheat Sheet: Basics, Advanced Queries, Administration, and Replication

This article provides a detailed collection of SQL Server commands and techniques covering database creation, table and index management, common DML statements, advanced set operators, various join types, grouping, pagination, maintenance tasks, replication setup, linked‑server usage, and a synchronization stored procedure.

Database AdministrationLinked ServerSQL
0 likes · 22 min read
Comprehensive SQL Server Cheat Sheet: Basics, Advanced Queries, Administration, and Replication
dbaplus Community
dbaplus Community
Jul 21, 2020 · Databases

What Are the Different Types of OLAP and How Do They Impact Performance?

This article provides a comprehensive overview of OLAP systems, classifying them by data volume and modeling approach, comparing MOLAP, ROLAP, HOLAP and HTAP, reviewing popular open‑source products, and detailing architectural, query‑optimization, vectorization, storage and resource‑management techniques that affect analytical warehouse performance.

Data WarehouseHTAPMOLAP
0 likes · 30 min read
What Are the Different Types of OLAP and How Do They Impact Performance?
Java Backend Technology
Java Backend Technology
Jul 21, 2020 · Databases

Boost MySQL Pagination Speed: Proven Techniques and Benchmarks

This article examines why full‑table scans on massive MySQL tables are slow, explains standard LIMIT‑based pagination, and presents several optimization strategies—including sub‑queries, ID‑range filtering, and temporary tables—backed by concrete performance measurements.

mysqlperformancequery optimization
0 likes · 10 min read
Boost MySQL Pagination Speed: Proven Techniques and Benchmarks
JD Retail Technology
JD Retail Technology
Jul 13, 2020 · Databases

Real‑Time Analytics Engine Based on ClickHouse: Architecture, MergeTree, Data Ingestion, and Query Optimization

This article describes how JD.com’s Algorithmic Intelligence team built a ClickHouse‑based real‑time analytics engine, covering ClickHouse fundamentals, MergeTree table design, Kafka‑Flink data pipelines, JDBC batch loading, query‑optimization techniques, and monitoring for handling billions of rows with sub‑second response times.

ClickHouseMergeTreedata ingestion
0 likes · 14 min read
Real‑Time Analytics Engine Based on ClickHouse: Architecture, MergeTree, Data Ingestion, and Query Optimization
Selected Java Interview Questions
Selected Java Interview Questions
Jul 3, 2020 · Databases

Understanding MySQL Index Structures: From Simple Tables to B+ Trees

This article explains how MySQL stores data using pages, page directories, and multi‑page structures, demonstrates why MySQL silently sorts rows on insert, and shows how these mechanisms combine into the B+‑tree index that optimizes query performance and supports clustering, non‑clustering, and composite indexes.

B+TreeComposite IndexDatabase Pages
0 likes · 24 min read
Understanding MySQL Index Structures: From Simple Tables to B+ Trees
360 Quality & Efficiency
360 Quality & Efficiency
Jun 12, 2020 · Databases

MongoDB Pagination, Query Optimization, and Index Design Guide

This article explains various MongoDB pagination strategies—including skip/limit, range queries, and sorting—covers performance monitoring with profiling, details index creation and design principles, and describes how to interpret explain plans for efficient query optimization.

MongoDBdatabaseindexing
0 likes · 13 min read
MongoDB Pagination, Query Optimization, and Index Design Guide
Top Architect
Top Architect
Jun 7, 2020 · Databases

MySQL Performance Optimization: Data Volume, Concurrency, Index Design, and SQL Tuning

This article presents a comprehensive guide to MySQL performance improvement, covering maximum data volume, connection limits, query latency targets, practical implementation principles, optimal table design, index classification and tuning, as well as detailed SQL optimizations such as batch processing, operator rewriting, and pagination techniques.

Index OptimizationSQL Tuningmysql
0 likes · 16 min read
MySQL Performance Optimization: Data Volume, Concurrency, Index Design, and SQL Tuning
ITPUB
ITPUB
Jun 3, 2020 · Databases

Why MySQL Ignored My Index: Charset Mismatch Triggers Full Table Scans

A MySQL join between a large and a small table ran for seconds because differing character sets forced implicit conversions that disabled the index, and the article shows how to diagnose the issue with EXPLAIN, fix it by aligning charsets, and avoid similar pitfalls.

CharsetJOINindex
0 likes · 7 min read
Why MySQL Ignored My Index: Charset Mismatch Triggers Full Table Scans
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
Java Captain
Java Captain
Apr 5, 2020 · Databases

Optimizing MySQL LIMIT Queries by Reducing Row Lookups

This article explains why large OFFSET values in MySQL LIMIT queries cause severe performance degradation and demonstrates how rewriting the query to fetch primary keys first and then joining reduces execution time from seconds to milliseconds, supported by buffer‑pool analysis and practical test results.

LIMITbuffer poolindex
0 likes · 8 min read
Optimizing MySQL LIMIT Queries by Reducing Row Lookups
Java Backend Technology
Java Backend Technology
Jan 26, 2020 · Databases

Why LIMIT with Large Offsets Slows MySQL Queries and How to Fix It

The article explains how using LIMIT with a large offset on a MySQL table forces the engine to scan hundreds of thousands of index rows and cluster‑index pages, dramatically increasing I/O, and shows a sub‑query join technique that reduces the scan to just the needed rows, cutting execution time from minutes to fractions of a second while also illustrating the impact on the InnoDB buffer pool.

LIMITmysqlperformance
0 likes · 10 min read
Why LIMIT with Large Offsets Slows MySQL Queries and How to Fix It
Big Data Technology & Architecture
Big Data Technology & Architecture
Jan 15, 2020 · Databases

Understanding and Using Hash Join in MySQL 8.0

This article explains the concept of Hash Join in MySQL 8.0, compares it with Nested Loop joins, shows how to enable or force it with server variables or hints, and presents performance benchmarks that demonstrate its speed advantages on large datasets.

Hash JoinPerformance TestingSQL
0 likes · 12 min read
Understanding and Using Hash Join in MySQL 8.0
Architecture Digest
Architecture Digest
Jan 13, 2020 · Databases

Understanding Index Usage and Slow Queries in MySQL

This article explains why using an index does not guarantee a fast query in MySQL, analyzes how slow‑query detection works, demonstrates full‑index scans, discusses index selectivity, the cost of row‑lookup (back‑table) operations, and shows how virtual columns and index condition push‑down can improve performance.

indexesmysqlquery optimization
0 likes · 12 min read
Understanding Index Usage and Slow Queries in MySQL
Big Data Technology & Architecture
Big Data Technology & Architecture
Dec 14, 2019 · Databases

MySQL Logical Architecture, Query Process, and Performance Optimization

This article explains MySQL's three‑layer logical architecture, the end‑to‑end query execution flow—including client/server protocol, query cache, parsing, cost‑based optimization, execution engine, and result delivery—followed by practical performance‑tuning advice on schema design, data types, index creation, and specific query optimizations such as COUNT(), JOINs, LIMIT pagination, and UNION handling.

Database PerformanceSQLindexing
0 likes · 34 min read
MySQL Logical Architecture, Query Process, and Performance Optimization
MaGe Linux Operations
MaGe Linux Operations
Dec 1, 2019 · Databases

Unlock MySQL Performance: Deep Dive into Query Optimization & Index Design

This article explains MySQL's logical architecture, query execution steps, client‑server protocol, query cache behavior, cost‑based optimizer mechanics, and practical index design strategies—including B+Tree fundamentals, covering indexes, and common pitfalls—to help developers achieve measurable performance improvements.

Database Performancecost‑based optimizerindex design
0 likes · 32 min read
Unlock MySQL Performance: Deep Dive into Query Optimization & Index Design
ITPUB
ITPUB
Aug 18, 2019 · Databases

100 Essential MySQL Interview Questions: Indexes, Transactions, and More

This comprehensive guide answers 100 common MySQL interview questions, covering index types and trade‑offs, transaction concepts and isolation levels, table design best practices, storage engine differences, and various performance‑related tips for developers.

Table Designquery optimizationstorage-engine
0 likes · 22 min read
100 Essential MySQL Interview Questions: Indexes, Transactions, and More
Qunar Tech Salon
Qunar Tech Salon
Jul 9, 2019 · Databases

SQL Fundamentals and Query Optimization Techniques for PostgreSQL

This article introduces SQL fundamentals, explains DDL/DML/DCL categories, and provides practical PostgreSQL query optimization techniques—including index selection, condition rewriting, sub‑query removal, expression and partial indexes, DDL decomposition, CTE usage, and key configuration parameters—to help developers and DBAs improve performance and maintainability.

Database PerformancePostgreSQLSQL
0 likes · 12 min read
SQL Fundamentals and Query Optimization Techniques for PostgreSQL
Java Captain
Java Captain
May 31, 2019 · Databases

Common MySQL Query Performance Issues and Optimization Techniques

This article examines frequent MySQL performance problems such as inefficient LIMIT pagination, implicit type conversion, sub‑query updates, mixed ordering, EXISTS usage, condition push‑down limits, early result set reduction, and intermediate result set optimization, providing rewritten SQL examples that dramatically improve execution speed.

SQLdatabaseindexes
0 likes · 11 min read
Common MySQL Query Performance Issues and Optimization Techniques
AntTech
AntTech
May 29, 2019 · Databases

OceanBase Query Optimizer: Challenges, Techniques, and Engineering Practices

This article examines the core challenges of query optimization in relational databases—accurate statistics, massive plan spaces, and efficient plan management—and explains how OceanBase addresses them through logical/physical row concepts, real‑time statistics, distributed two‑stage planning, adaptive caching, and plan evolution mechanisms.

Cost ModelLSM-TreeOceanBase
0 likes · 15 min read
OceanBase Query Optimizer: Challenges, Techniques, and Engineering Practices
dbaplus Community
dbaplus Community
May 26, 2019 · Databases

Why Is MySQL Query Slow? Common Causes and How to Diagnose Them

This article explains why a MySQL statement may run slowly—whether only occasionally or every time—by examining redo‑log flushing, lock contention, missing or misused indexes, optimizer mis‑estimates, and provides practical commands to identify and resolve each issue.

SQLdatabaseindexes
0 likes · 12 min read
Why Is MySQL Query Slow? Common Causes and How to Diagnose Them
Programmer DD
Programmer DD
May 26, 2019 · Databases

How to Speed Up Large‑Scale MySQL Pagination: Practical Tips & Benchmarks

This article explains why traditional MySQL pagination (ORDER BY … LIMIT N,M) becomes painfully slow on tens of millions of rows, analyzes the root causes, and presents concrete optimizations such as covering‑index delayed joins, bookmark‑based scans, and query rewrites that can cut execution time to a third of the original.

Bookmark Scancovering indexdelayed join
0 likes · 9 min read
How to Speed Up Large‑Scale MySQL Pagination: Practical Tips & Benchmarks
Java Captain
Java Captain
Apr 8, 2019 · Databases

Understanding MySQL Execution Process: Architecture, Query and Update Flow

This article explains MySQL's internal architecture and the step‑by‑step execution flow of SELECT and UPDATE statements, covering server layers, storage engines, parsers, optimizers, executors, and the role of binlog and redo log in ensuring data consistency.

Database ArchitectureInnoDBSQL Execution
0 likes · 10 min read
Understanding MySQL Execution Process: Architecture, Query and Update Flow
MaGe Linux Operations
MaGe Linux Operations
Mar 19, 2019 · Databases

Unlock MySQL Performance: Deep Dive into Query Optimization & Architecture

This article explains MySQL's logical architecture, query processing steps, and the inner workings of its optimizer, cache, and execution engine, then offers practical performance‑tuning advice on schema design, index creation, and specific query patterns to help developers make informed optimization decisions.

Database Architectureindex designmysql
0 likes · 35 min read
Unlock MySQL Performance: Deep Dive into Query Optimization & Architecture
Liangxu Linux
Liangxu Linux
Feb 20, 2019 · Databases

19 Essential MySQL Optimization Techniques Every Developer Should Know

This guide presents 19 practical MySQL optimization tips—including using EXPLAIN, avoiding SELECT *, limiting IN lists, preferring UNION ALL, improving pagination, leveraging full‑text indexes, and proper join strategies—to help developers write faster, more efficient queries.

Full‑Text SearchJOINSQL Best Practices
0 likes · 12 min read
19 Essential MySQL Optimization Techniques Every Developer Should Know
Zhuanzhuan Tech
Zhuanzhuan Tech
Jan 11, 2019 · Databases

Differences Between TiDB and MySQL: Transactions, Queries, Server‑Side Prepared Statements, and Batch Processing

This article examines TiDB, a world‑class open‑source distributed NewSQL database, comparing its transaction and query behavior with MySQL, discussing underlying Percolator model, server‑side prepared statements, batch processing techniques, and practical optimization strategies for developers.

Batch ProcessingTiDBdistributed database
0 likes · 10 min read
Differences Between TiDB and MySQL: Transactions, Queries, Server‑Side Prepared Statements, and Batch Processing
360 Tech Engineering
360 Tech Engineering
Jan 7, 2019 · Databases

SQL Query Analysis and Access Path Strategies

This article explains how relational optimizers validate, analyze, and transform SQL statements into executable code, detailing the four-step optimization process, query‑analysis factors, cost‑based access‑path selection, table scans, index lookups, and the role of data prefetching in improving performance.

Access PathDatabase PerformanceIndex Scan
0 likes · 12 min read
SQL Query Analysis and Access Path Strategies
Youzan Coder
Youzan Coder
Nov 16, 2018 · Databases

Optimizing Large-Scale Pagination Queries in MySQL

When paginating millions of rows in MySQL, avoid large OFFSET scans by using delayed joins or bookmark techniques that first fetch primary‑key values via covering indexes, then retrieve the needed rows, dramatically reducing I/O and query latency.

bookmark paginationdatabasedelayed join
0 likes · 10 min read
Optimizing Large-Scale Pagination Queries in MySQL
360 Quality & Efficiency
360 Quality & Efficiency
Sep 29, 2018 · Databases

Diagnosing and Optimizing MySQL Query Performance Issues

This article explains how large data volumes and differing environments can degrade MySQL query performance, demonstrates using EXPLAIN to analyze index usage and row scans, and offers practical steps such as adding filters, pagination, and code adjustments to improve speed.

Environmentindexingmysql
0 likes · 6 min read
Diagnosing and Optimizing MySQL Query Performance Issues
ITPUB
ITPUB
Jul 7, 2018 · Databases

Unlocking MySQL: How SQL Parsing Works and Boosts DBA Efficiency

This article explains why protecting database systems is critical, reviews existing SQL‑analysis tools, and dives deep into MySQL's lexical and syntax parsing techniques—including Bison‑generated parsers, core data structures, and practical applications such as useless‑condition removal and SQL feature generation—to help DBAs automate and optimize their workflows.

BisonDBA toolsSQL parsing
0 likes · 15 min read
Unlocking MySQL: How SQL Parsing Works and Boosts DBA Efficiency
MaGe Linux Operations
MaGe Linux Operations
May 21, 2018 · Databases

Unlock MySQL Performance: Deep Dive into Query Optimization Principles

This article explains MySQL's logical architecture, query execution flow, and the inner workings of its optimizer, then provides practical performance‑tuning advice—including index design, query cache handling, and specific query‑type optimizations—to help developers make informed decisions for real‑world workloads.

index designperformance tuningquery optimization
0 likes · 38 min read
Unlock MySQL Performance: Deep Dive into Query Optimization Principles
Efficient Ops
Efficient Ops
May 7, 2018 · Databases

Unveiling MySQL Query Optimization: Architecture, Execution, and Practical Tips

This article demystifies MySQL query optimization by explaining the server's logical architecture, the end‑to‑end query processing flow, the role of the client/server protocol, query cache, parsing, optimizer, execution engine, and result delivery, and then offers concrete performance‑tuning recommendations on schema design, data types, indexing strategies, and specific query patterns such as COUNT(), JOIN, LIMIT pagination, and UNION.

Database PerformanceSQLindexing
0 likes · 35 min read
Unveiling MySQL Query Optimization: Architecture, Execution, and Practical Tips
Java Captain
Java Captain
Apr 6, 2018 · Databases

Understanding MySQL Indexes and Using EXPLAIN for Query Optimization

This article explains how MySQL indexes work, why queries can become slow, how to interpret the EXPLAIN output—including id, select_type, table, type, possible_keys, key, key_len, ref, rows, and extra columns—and provides practical examples and optimization cases to improve query performance while balancing the cost of maintaining indexes.

Database PerformanceSQLindex
0 likes · 13 min read
Understanding MySQL Indexes and Using EXPLAIN for Query Optimization
ITPUB
ITPUB
Mar 26, 2018 · Databases

30 Essential SQL Query Optimization Tips to Avoid Full Table Scans

This article presents thirty practical SQL tuning guidelines—ranging from avoiding certain WHERE‑clause operators and functions to proper index usage and set‑based alternatives—that help prevent full table scans and improve overall database performance.

Database PerformanceSQLbest practices
0 likes · 11 min read
30 Essential SQL Query Optimization Tips to Avoid Full Table Scans
ITPUB
ITPUB
Mar 13, 2018 · Databases

Optimizing Large-Scale Oracle Queries with Temporary Tables

This article examines a high‑volume Oracle query scenario, explains why using multiple IN clauses on millions of rows leads to costly full‑table scans, and presents three alternative strategies—including a single‑SQL join, UNION ALL view, and temporary‑table approaches—along with practical examples and performance considerations.

Database PerformanceOracleSQL
0 likes · 10 min read
Optimizing Large-Scale Oracle Queries with Temporary Tables
AntTech
AntTech
Jan 4, 2018 · Databases

Report on VLDB 2017 Conference: Insights and Highlights from Database Research

Attending VLDB 2017 in Munich, the report summarizes the conference’s broad coverage of database research—from new hardware‑accelerated prototypes and Spark‑based big‑data processing to Oracle and SAP HANA case studies, keynotes, notable papers, and reflections on industry trends and Chinese contributions.

Big DataHardware accelerationVLDB
0 likes · 22 min read
Report on VLDB 2017 Conference: Insights and Highlights from Database Research
ITPUB
ITPUB
Dec 12, 2017 · Databases

Understanding PostgreSQL’s Subquery Planner: How Query Optimization Works

This article explains how PostgreSQL transforms and rewrites query trees, why a completed transform‑rewrite tree may not be optimal, and details the subquery_planner’s role, tuple_fraction handling, and the step‑by‑step logical optimization process used to generate efficient execution plans.

Planner HookPostgreSQLSQL
0 likes · 7 min read
Understanding PostgreSQL’s Subquery Planner: How Query Optimization Works
ITPUB
ITPUB
Dec 7, 2017 · Databases

Master MySQL Query Optimization: From Architecture to High‑Performance Indexing

This article explains MySQL's logical architecture, the step‑by‑step query execution process, and provides practical performance‑tuning advice—including schema design, data‑type choices, index strategies, and specific query optimizations such as COUNT, JOIN, LIMIT pagination, and UNION—backed by code examples and diagrams.

databasemysqlperformance
0 likes · 36 min read
Master MySQL Query Optimization: From Architecture to High‑Performance Indexing
ITPUB
ITPUB
Nov 27, 2017 · Databases

Essential Database Design and Query Optimization Tips for Faster SQL Performance

This article outlines essential database design principles and a comprehensive set of query optimization techniques, covering row size limits, appropriate data types, field length choices, index usage, avoiding costly WHERE clause patterns, and best practices for temporary tables, transactions, and result set handling to boost SQL performance.

Database designSQLbest practices
0 likes · 13 min read
Essential Database Design and Query Optimization Tips for Faster SQL Performance
ITPUB
ITPUB
Nov 7, 2017 · Databases

Why MySQL Ignored My Index and How to Speed Up Periodic Deletion Queries

The article examines why a MySQL DELETE statement with a composite index on biz_date and status still triggers a full‑table scan, shows EXPLAIN output, tests forced index usage, and ultimately demonstrates that narrowing the date range in the query dramatically reduces rows examined and improves performance.

SQLmysqlperformance
0 likes · 7 min read
Why MySQL Ignored My Index and How to Speed Up Periodic Deletion Queries
ITPUB
ITPUB
Oct 14, 2017 · Databases

Cutting a Slow Oracle Search Query from Cost 13902 to Under 100

This article walks through diagnosing a sluggish Oracle search query with many optional filters, removing unnecessary joins and function calls, applying conditional MyBatis joins, and creating composite indexes to dramatically lower the execution plan cost from 13902 to under 100.

MyBatisOracleSQL
0 likes · 11 min read
Cutting a Slow Oracle Search Query from Cost 13902 to Under 100
ITPUB
ITPUB
Oct 8, 2017 · Databases

SQL Server Field Types, Constraints, and Index Design: Essential Best Practices

This guide outlines best practices for SQL Server database design, covering recommended field types, primary key and null policies, index creation rules, low‑selectivity column handling, and a comprehensive set of query‑writing conventions to improve performance and maintainability.

Database designSQL Serverfield types
0 likes · 18 min read
SQL Server Field Types, Constraints, and Index Design: Essential Best Practices
ITPUB
ITPUB
Sep 7, 2017 · Databases

Master MySQL Index Usage: When and How Indexes Improve Queries

This guide explains how MySQL decides whether to use an index for range queries, LIKE patterns, and ORDER BY operations, detailing key_len calculation, index key vs filter vs table filter concepts, and practical examples for BETWEEN and sorting optimization.

BETWEENOrder Byindex
0 likes · 10 min read
Master MySQL Index Usage: When and How Indexes Improve Queries
ITPUB
ITPUB
Mar 17, 2017 · Databases

Master SQL Query Execution Order and Performance Optimization Tips

This article explains the logical and physical execution order of SQL statements, offers practical tips for returning only needed data, reducing redundant work, using temporary tables wisely, optimizing subqueries and indexes, and provides concrete code examples to improve query performance.

SQLdatabaseperformance
0 likes · 15 min read
Master SQL Query Execution Order and Performance Optimization Tips
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
ITPUB
ITPUB
Mar 2, 2017 · Databases

Mastering SQL Server: Understanding Query Execution Order and Optimization Tips

This article explains SQL Server's logical query execution sequence, details the physical step‑by‑step processing, and provides practical optimization advice such as avoiding SELECT *, using proper indexes, handling temporary tables, rewriting subqueries, and safely managing transactions to improve performance and maintainability.

Execution OrderSQL ServerSubqueries
0 likes · 16 min read
Mastering SQL Server: Understanding Query Execution Order and Optimization Tips
dbaplus Community
dbaplus Community
Feb 26, 2017 · Databases

Uncovering Hidden Pitfalls of Oracle's Cost‑Based Optimizer and How to Fix Them

This article walks through common traps in Oracle's Cost‑Based Optimizer (CBO), explains why query transformations, FILTER operations, and inaccurate statistics can cripple performance, and provides practical solutions—including NULL‑AWARE anti‑joins, hint usage, SQLT tooling, and SQL rewrites—to dramatically speed up problematic queries.

CBOOracleperformance
0 likes · 33 min read
Uncovering Hidden Pitfalls of Oracle's Cost‑Based Optimizer and How to Fix Them
ITPUB
ITPUB
Feb 13, 2017 · Databases

Mastering SQL: Joins, Normal Forms, Indexes, and Optimization Techniques

This article explains SQL join types, the three normal forms, table creation and alteration commands, data integrity constraints, practical query‑optimization tips, the roles and differences of clustered and non‑clustered indexes, and the distinctions between stored procedures and functions.

Database designJoinsSQL
0 likes · 7 min read
Mastering SQL: Joins, Normal Forms, Indexes, and Optimization Techniques
ITPUB
ITPUB
Jan 18, 2017 · Databases

Essential Database Design and Query Optimization Tips for Faster SQL Performance

This article provides practical guidelines for designing efficient database schemas and optimizing SQL queries, covering row size limits, data type choices, index usage, common pitfalls in WHERE clauses, and best practices for temporary tables and transaction handling to improve overall database performance.

Database designSQLindexes
0 likes · 11 min read
Essential Database Design and Query Optimization Tips for Faster SQL Performance
ITPUB
ITPUB
Jan 10, 2017 · Databases

5 Practical SQL Query Tricks to Boost Database Readability and Performance

This article presents five useful Oracle SQL techniques—including string concatenation, DISTINCT, WHERE clauses, flexible COUNT usage, and selecting only necessary columns—to improve query readability, eliminate duplicate rows, and enhance overall database performance.

OracleSQLTips
0 likes · 9 min read
5 Practical SQL Query Tricks to Boost Database Readability and Performance
Hulu Beijing
Hulu Beijing
Dec 20, 2016 · Big Data

How Hulu Supercharges OLAP Queries with CarbonData: Real‑World Optimizations

This article describes Hulu’s real‑world OLAP query optimization, covering the fundamentals of OLAP, comparisons of row‑ and column‑based storage formats, detailed indexing mechanisms of Parquet, ORC and CarbonData, and the specific schema, shuffle, block size, speculation and GC tuning techniques that enabled CarbonData to dramatically accelerate wide‑table queries on SparkSQL.

Big DataCarbonDataColumnar Storage
0 likes · 17 min read
How Hulu Supercharges OLAP Queries with CarbonData: Real‑World Optimizations
Practical DevOps Architecture
Practical DevOps Architecture
Dec 8, 2016 · Databases

SQL Query Optimization Tips and Best Practices

This article presents a comprehensive collection of practical SQL performance tuning guidelines, covering index usage, query rewriting, avoiding costly operators, proper data types, efficient joins, and view creation to help developers write faster, more resource‑efficient database queries.

Database TuningSQLindexes
0 likes · 11 min read
SQL Query Optimization Tips and Best Practices
dbaplus Community
dbaplus Community
Nov 15, 2016 · Databases

How I Cut a 4‑Minute Oracle Query to 3.5 Seconds: A Step‑by‑Step SQL Optimization Tale

After a typhoon delayed work, the author tackled a 347‑line Oracle SQL that took over four minutes to return results, dissected its massive subqueries and views, applied three rounds of restructuring with WITH clauses and driver‑table tactics, and ultimately reduced the total runtime to just 3.5 seconds while dramatically speeding up deep data extraction.

Driver TableOracleSQL
0 likes · 12 min read
How I Cut a 4‑Minute Oracle Query to 3.5 Seconds: A Step‑by‑Step SQL Optimization Tale
ITPUB
ITPUB
Nov 14, 2016 · Databases

Optimizing Large‑Scale Oracle Queries with Temporary Tables: Strategies and Trade‑offs

This article examines a high‑volume Oracle query scenario, critiques the current multi‑IN approach, and presents three alternative solutions—including a single‑SQL join, a UNION ALL view, and the use of global temporary tables—detailing their performance implications and practical trade‑offs.

Database PerformanceIndex ScanOracle
0 likes · 10 min read
Optimizing Large‑Scale Oracle Queries with Temporary Tables: Strategies and Trade‑offs
dbaplus Community
dbaplus Community
Nov 9, 2016 · Databases

Mastering SQL Server Timeout Errors: Diagnosis and Tuning Guide

This article explains the various timeout scenarios in SQL Server‑backed web applications—including ASP.NET, IIS, WebService, SSMS, remote login, and linked‑server timeouts—provides diagnostic queries such as the Connectivity Ring Buffer, and offers concrete tuning steps and best‑practice recommendations to resolve and prevent them.

Linked ServerSQL ServerTimeout
0 likes · 16 min read
Mastering SQL Server Timeout Errors: Diagnosis and Tuning Guide
MaGe Linux Operations
MaGe Linux Operations
Oct 20, 2016 · Databases

Boost Your SQL SELECT Performance: Proven Checklist & Practical Tips

This guide presents a concise, experience‑based checklist for optimizing SQL SELECT statements, covering index verification, dataset reduction, column selection, unnecessary table removal, outer join elimination, and computed column cleanup, each illustrated with real‑world examples and visual aids.

SQLdatabasesindexes
0 likes · 6 min read
Boost Your SQL SELECT Performance: Proven Checklist & Practical Tips
ITPUB
ITPUB
Oct 19, 2016 · Databases

Why InnoDB Returns Rows in Primary‑Key Order When Scanning Without Indexes

This article demonstrates how InnoDB returns rows in primary‑key order during full‑table scans, while queries that use a secondary index follow the leaf‑node order of that index, and it compares performance implications of index‑only scans versus clustered‑index scans.

InnoDBdatabaseindex
0 likes · 12 min read
Why InnoDB Returns Rows in Primary‑Key Order When Scanning Without Indexes
Java Backend Technology
Java Backend Technology
Oct 15, 2016 · Databases

Boost Query Speed in Million-Row Databases: Proven Optimization Techniques

This article presents a comprehensive set of practical strategies for improving database query performance, covering index design, SQL statement refinements, Java backend considerations, hardware tuning, and storage‑procedure usage to accelerate operations on large‑scale relational databases.

indexingperformance tuningquery optimization
0 likes · 13 min read
Boost Query Speed in Million-Row Databases: Proven Optimization Techniques
ITPUB
ITPUB
Sep 13, 2016 · Backend Development

Auto‑Detect Useful Column Groups in Oracle 12c to Improve Query Plans

This guide shows how to use Oracle 12c's DBMS_STATS.SEED_COL_USAGE and REPORT_COL_USAGE to automatically identify useful column groups, create extended statistics, and verify the impact on execution plans with concrete SQL examples.

DBMS_STATSExtended StatsOracle
0 likes · 8 min read
Auto‑Detect Useful Column Groups in Oracle 12c to Improve Query Plans
ITPUB
ITPUB
Jul 29, 2016 · Databases

30 Essential SQL Query Optimization Tips to Avoid Full Table Scans

This guide presents thirty practical SQL optimization techniques—ranging from index usage and avoiding costly operators to rewriting expressions and minimizing temp objects—to help developers prevent full table scans and boost database performance.

SQLindexesquery optimization
0 likes · 11 min read
30 Essential SQL Query Optimization Tips to Avoid Full Table Scans
dbaplus Community
dbaplus Community
May 25, 2016 · Databases

How Parallel Execution Supercharges SQL Server Queries—and the Pitfalls to Avoid

This article explains the theory behind SQL Server's parallel execution, illustrates its performance gains with Amdahl's Law, lists operators that block parallelism, discusses configuration settings, warns of deadlocks and thread starvation, and presents practical MapReduce‑style optimizations for real‑world workloads.

Amdahl's LawMapReduceParallel Execution
0 likes · 16 min read
How Parallel Execution Supercharges SQL Server Queries—and the Pitfalls to Avoid
ITPUB
ITPUB
May 5, 2016 · Databases

Top 50 SQL Server Query Optimization Tips to Boost Performance

This comprehensive guide enumerates over forty common causes of slow SQL Server queries and provides detailed optimization techniques—including indexing strategies, hardware upgrades, partitioning, cursor handling, and configuration tweaks—to dramatically improve query performance and reduce resource bottlenecks.

SQL Serverdatabaseindexes
0 likes · 21 min read
Top 50 SQL Server Query Optimization Tips to Boost Performance
Qunar Tech Salon
Qunar Tech Salon
Apr 30, 2016 · Big Data

Designing and Optimizing Log Storage and Query in HBase

This article analyzes the characteristics of log data, explains why HBase is chosen for log storage, discusses the shortcomings of self‑built indexes, and presents optimization strategies such as rowKey design, filter usage, coprocessor integration, and third‑party indexing to improve query performance.

HBaseRowkey Designindexing
0 likes · 12 min read
Designing and Optimizing Log Storage and Query in HBase
ITPUB
ITPUB
Dec 29, 2015 · Big Data

How SparkSQL Executes Queries Faster Than Hive: A Deep Dive

This article explains SparkSQL's query processing pipeline—from parsing and logical planning through optimization and physical execution—highlighting why it often outperforms Hive on MapReduce by reducing I/O, minimizing shuffle stages, and reusing JVMs.

Big DataHiveSparkSQL
0 likes · 13 min read
How SparkSQL Executes Queries Faster Than Hive: A Deep Dive
ITPUB
ITPUB
Dec 21, 2015 · Databases

Master MySQL Indexes: BTREE, Hash, and Query Optimization Secrets

This article explains MySQL's indexing mechanisms—including BTREE and hash structures, page layout, index types, and practical query patterns—while showing how to interpret EXPLAIN output and avoid common pitfalls for efficient database performance.

BTreeHash Indexdatabase
0 likes · 19 min read
Master MySQL Indexes: BTREE, Hash, and Query Optimization Secrets
dbaplus Community
dbaplus Community
Nov 18, 2015 · Databases

Demystifying DB2 Optimizer: How Cost Models Shape Query Performance

This article explains the inner workings of the DB2 optimizer, its four-step processing flow, cost‑based decision making, and detailed examples comparing full‑table and index scans, followed by practical tuning tips and a Q&A session for real‑world query optimization.

Cost ModelDB2Database Performance
0 likes · 19 min read
Demystifying DB2 Optimizer: How Cost Models Shape Query Performance