BestHub
Sign in
Tagged articles

indexes

277 articles · Page 3 of 3
Big Data Technology & Architecture
Big Data Technology & Architecture
Apr 12, 2020 · Databases

Comprehensive MySQL Fundamentals and Advanced Topics Overview

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

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

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

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

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

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

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

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

Master MySQL Indexes: Differences, Composite Strategies & Performance Hacks

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

DatabaseMySQLOptimization
0 likes · 15 min read
Master MySQL Indexes: Differences, Composite Strategies & Performance Hacks
ITPUB
ITPUB
Mar 5, 2020 · Databases

Master MySQL: Transactions, Indexes, Storage Engines, and Performance Optimization

This comprehensive guide explains MySQL fundamentals, transaction handling, ACID properties, isolation levels, indexing strategies, storage engine differences, lock mechanisms, optimistic vs pessimistic locking, and techniques for optimizing large tables in production environments.

Isolation LevelsMySQLStorage Engines
0 likes · 22 min read
Master MySQL: Transactions, Indexes, Storage Engines, and Performance Optimization
ITPUB
ITPUB
Feb 22, 2020 · Databases

12 Practical SQL Optimization Tips to Speed Up Your Queries

This article presents a concise collection of twelve actionable SQL tuning techniques—including using proper comparison operators, LIMIT 1, appropriate data types, breaking large statements, UNION ALL, consistent query formatting, avoiding SELECT *, indexing WHERE/JOIN/ORDER BY columns, pagination with LIMIT, and leveraging EXPLAIN—to help developers improve database performance.

Query PlanningSQLdatabase optimization
0 likes · 5 min read
12 Practical SQL Optimization Tips to Speed Up Your Queries
Liangxu Linux
Liangxu Linux
Feb 18, 2020 · Databases

Master MySQL Transactions, Indexes, and Locking: From ACID to Large‑Table Optimization

This guide explains MySQL fundamentals—including what a database is, transaction concepts and ACID properties, isolation levels and their effects, index structures and the left‑most prefix rule, storage engine differences, lock algorithms, and practical techniques for optimizing large tables such as partitioning and sharding.

DatabaseIsolation LevelsMySQL
0 likes · 23 min read
Master MySQL Transactions, Indexes, and Locking: From ACID to Large‑Table Optimization
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.

MySQLQuery OptimizationSlow Query
0 likes · 12 min read
Understanding Index Usage and Slow Queries in MySQL
Programmer DD
Programmer DD
Dec 25, 2019 · Databases

How MySQL Locks DELETE Rows: MVCC, Isolation Levels, and Index Types Explained

This article analyzes how MySQL/InnoDB applies row-level locks for DELETE and SELECT statements under various index configurations and isolation levels, explaining MVCC, current vs. snapshot reads, two‑phase locking, gap and next‑key locks, and the impact of primary, unique, non‑unique, and missing indexes.

InnoDBIsolation LevelsMVCC
0 likes · 15 min read
How MySQL Locks DELETE Rows: MVCC, Isolation Levels, and Index Types Explained
21CTO
21CTO
Nov 21, 2019 · Databases

How I Reduced a 30,000‑second MySQL Query to 0.001s with Indexes & Joins

This article walks through a real‑world MySQL performance case where a nested sub‑query on millions of rows took over eight hours, explains why the plan used full table scans, and shows step‑by‑step index creation and query rewrites that cut the execution time to a millisecond.

JOINMySQLSQL Optimization
0 likes · 7 min read
How I Reduced a 30,000‑second MySQL Query to 0.001s with Indexes & Joins
Big Data Technology Architecture
Big Data Technology Architecture
Aug 29, 2019 · Databases

19 Common MySQL Optimization Techniques

This article presents nineteen practical MySQL optimization methods—including using EXPLAIN, limiting IN clause size, specifying columns in SELECT, proper use of LIMIT, avoiding costly ORDER BY RAND(), choosing between IN and EXISTS, leveraging full‑text indexes, and applying join and index best practices—to improve query performance and reduce resource consumption.

DatabaseMySQLOptimization
0 likes · 11 min read
19 Common MySQL Optimization Techniques
Open Source Tech Hub
Open Source Tech Hub
Aug 27, 2019 · Databases

Unveiling MySQL InnoDB: From Instances to Page Storage Architecture

This article explains MySQL’s fundamental concepts, distinguishing databases from instances, outlines the three‑layer MySQL architecture, and dives deep into InnoDB’s storage hierarchy—from tablespaces, pages, and row formats to .frm/.ibd files, record overflow handling, and the B+‑tree index structures that power fast queries.

Database ArchitectureInnoDBMySQL
0 likes · 11 min read
Unveiling MySQL InnoDB: From Instances to Page Storage Architecture
Qunar Tech Salon
Qunar Tech Salon
Aug 13, 2019 · Databases

Efficient Deduplication of Large MySQL Tables Using Indexes, Variables, and Window Functions

This article demonstrates how to efficiently remove duplicate rows from a million‑record MySQL table by comparing created_time and item_name, exploring various approaches such as correlated subqueries, joins, user‑defined variables, index optimization, window functions, and parallel execution with shell scripts and MySQL events to achieve significant performance gains.

MySQLSQL PerformanceWindow Functions
0 likes · 21 min read
Efficient Deduplication of Large MySQL Tables Using Indexes, Variables, and Window Functions
21CTO
21CTO
Jul 23, 2019 · Databases

Master MySQL Fundamentals: Transactions, Indexes, and Performance Optimization

This comprehensive guide covers MySQL basics, transaction concepts and ACID properties, isolation levels, common concurrency problems, indexing principles, storage engine differences, lock mechanisms, and practical optimization techniques for large tables, providing clear explanations and useful SQL examples.

MySQLOptimizationStorage Engines
0 likes · 23 min read
Master MySQL Fundamentals: Transactions, Indexes, and Performance Optimization
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.

MySQLSQL Optimizationexecution plan
0 likes · 12 min read
How to Decode MySQL Execution Plans for Faster Queries
Efficient Ops
Efficient Ops
Jun 28, 2019 · Databases

Master MySQL Optimization: 19 Practical EXPLAIN Tips and Best Practices

This guide presents nineteen essential MySQL optimization techniques—including effective use of EXPLAIN, proper handling of IN and EXISTS, avoiding SELECT *, limiting rows, optimizing ORDER BY, leveraging UNION ALL, employing full‑text indexes, and advanced join strategies—to help developers write faster, more efficient queries.

EXPLAINJOINMySQL
0 likes · 12 min read
Master MySQL Optimization: 19 Practical EXPLAIN Tips and Best Practices
Programmer DD
Programmer DD
Jun 21, 2019 · Databases

Master MySQL EXPLAIN: Decode Execution Plans Like a Pro

This article walks you through using MySQL's EXPLAIN command to analyze query execution plans, explains each column in the output, shows how to interpret IDs, select types, tables, access types, possible and actual indexes, key lengths, row estimates, and extra information, and provides practical code examples for better performance tuning.

Database PerformanceEXPLAINMySQL
0 likes · 14 min read
Master MySQL EXPLAIN: Decode Execution Plans Like a Pro
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.

DatabaseMySQLQuery Optimization
0 likes · 11 min read
Common MySQL Query Performance Issues and Optimization Techniques
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.

DatabaseMySQLQuery Optimization
0 likes · 12 min read
Why Is MySQL Query Slow? Common Causes and How to Diagnose Them
Efficient Ops
Efficient Ops
May 7, 2019 · Databases

Master MySQL: Essential Tips for Data Types, Indexes, and Query Optimization

This guide compiles essential MySQL 5.5 techniques for teams without a DBA, covering storage engine characteristics, data type selection, index design—including composite, prefix, and covering indexes—and practical query optimizations such as reducing scanned rows, avoiding redundant indexes, and improving execution plans.

Data TypesMySQLSQL Performance
0 likes · 22 min read
Master MySQL: Essential Tips for Data Types, Indexes, and Query Optimization
Java Captain
Java Captain
Apr 10, 2019 · Databases

MySQL Interview Questions and Answers: Normal Forms, Auto‑Increment IDs, ACID, Data Types, Joins, Indexes, Transactions, Engines, Locks, and Optimization

This article provides concise explanations of common MySQL interview topics, covering the three normal forms, auto‑increment behavior, version retrieval, ACID properties, char vs varchar, float vs double, join types, index implementation, isolation levels, storage engines, lock mechanisms, troubleshooting commands, and performance‑tuning tips.

DatabaseMySQLindexes
0 likes · 11 min read
MySQL Interview Questions and Answers: Normal Forms, Auto‑Increment IDs, ACID, Data Types, Joins, Indexes, Transactions, Engines, Locks, and Optimization
dbaplus Community
dbaplus Community
Nov 27, 2018 · Databases

Master MySQL Performance: Indexes, EXPLAIN Insights, and Slow Query Tactics

This guide compiles essential MySQL optimization techniques—including index cardinality, common index pitfalls, effective use of EXPLAIN, handling character sets, online schema changes, and practical slow‑query analysis commands—providing developers with actionable tips to improve query performance and avoid common pitfalls.

EXPLAINMySQLOptimization
0 likes · 19 min read
Master MySQL Performance: Indexes, EXPLAIN Insights, and Slow Query Tactics
Java Backend Technology
Java Backend Technology
Sep 8, 2018 · Databases

Master MySQL Quickly: Essential Tips, Best Practices, and Common Pitfalls

This comprehensive guide walks you through mastering MySQL by covering server configuration choices, storage engine selection, data type recommendations, index strategies, backup methods, logging options, and practical advice on triggers, views, stored procedures, and character set handling, all aimed at boosting performance and avoiding common mistakes.

BackupDatabaseMySQL
0 likes · 26 min read
Master MySQL Quickly: Essential Tips, Best Practices, and Common Pitfalls
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Aug 21, 2018 · Databases

Mastering MySQL: Keys, Transactions, Indexes, Joins, and Optimization Essentials

This article explains fundamental MySQL concepts including primary, candidate, super and foreign keys, transaction ACID properties, view creation, differences among DROP, DELETE and TRUNCATE, index structures and types, join variations, normalization forms, optimization techniques, replication mechanisms, engine distinctions, and logging formats.

DatabaseMySQLSQL
0 likes · 29 min read
Mastering MySQL: Keys, Transactions, Indexes, Joins, and Optimization Essentials
Java Captain
Java Captain
Jul 7, 2018 · Databases

Understanding MySQL Indexes, B+Tree vs Hash, Partitioning, and Redis Fundamentals

This article explains why auto‑increment primary keys are preferred in MySQL, how B+Tree and hash indexes differ, the benefits of composite and partitioned indexes, isolation levels, MVCC, row‑level locking, triggers, stored procedures, optimization tips, MyISAM vs InnoDB, table design guidelines, and also covers Redis architecture, persistence, replication, and eviction policies.

B+TreeDatabaseMySQL
0 likes · 28 min read
Understanding MySQL Indexes, B+Tree vs Hash, Partitioning, and Redis Fundamentals
Java Architect Essentials
Java Architect Essentials
Jun 4, 2018 · Databases

Fundamental SQL Commands and Database Design Basics

This article provides a concise introduction to essential SQL concepts, covering database creation, manipulation, table design, constraints, indexes, and common DDL statements, making it a useful reference for beginners and experienced developers alike.

DDLSQLconstraints
0 likes · 7 min read
Fundamental SQL Commands and Database Design Basics
ITFLY8 Architecture Home
ITFLY8 Architecture Home
May 8, 2018 · Databases

21 Essential MySQL Performance Tips Every Developer Should Know

This article presents a comprehensive set of MySQL optimization techniques—including query‑cache tuning, proper use of EXPLAIN, indexing strategies, avoiding costly functions, and leveraging prepared statements—to help developers eliminate database bottlenecks and boost web‑application performance.

MySQLSQLdatabase tuning
0 likes · 21 min read
21 Essential MySQL Performance Tips Every Developer Should Know
ITPUB
ITPUB
Apr 6, 2018 · Databases

Understanding MySQL InnoDB: Architecture, Storage, Indexes, Locks, and Transactions

This article provides a comprehensive, step‑by‑step overview of MySQL's InnoDB storage engine, covering database vs instance definitions, internal processes, tablespace layout, file formats, record layouts, B‑tree indexes, lock types, and transaction isolation levels for developers seeking a solid foundation.

DatabaseInnoDBLocks
0 likes · 26 min read
Understanding MySQL InnoDB: Architecture, Storage, Indexes, Locks, and Transactions
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 PerformanceQuery OptimizationSQL
0 likes · 11 min read
30 Essential SQL Query Optimization Tips to Avoid Full Table Scans
ITPUB
ITPUB
Jan 5, 2018 · Databases

Why PostgreSQL Stands Out: Essential Features and Extensions Explained

This article outlines the most compelling reasons to choose PostgreSQL, covering its advanced data types like JSONB and Range, powerful extensions such as Citus, HyperLogLog and PostGIS, logical replication, rich indexing options, upsert support, foreign data wrappers, and a host of legacy capabilities.

DatabaseExtensionsJSONB
0 likes · 10 min read
Why PostgreSQL Stands Out: Essential Features and Extensions Explained
ITPUB
ITPUB
Dec 11, 2017 · Databases

19 Essential MySQL Optimization Tips to Boost Query Performance

This guide walks through practical MySQL performance improvements—including using EXPLAIN, limiting IN lists, selecting specific columns, applying LIMIT 1, avoiding ORDER BY RAND(), preferring UNION ALL, proper index usage, forcing indexes, handling range queries, and optimizing JOINs—to help developers write faster, more efficient SQL statements.

EXPLAINMySQLSQL Optimization
0 likes · 12 min read
19 Essential MySQL Optimization Tips to Boost Query Performance
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 DesignQuery OptimizationSQL
0 likes · 13 min read
Essential Database Design and Query Optimization Tips for Faster SQL Performance
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 DesignField TypesQuery Optimization
0 likes · 18 min read
SQL Server Field Types, Constraints, and Index Design: Essential Best Practices
dbaplus Community
dbaplus Community
Sep 27, 2017 · Databases

Unlock MySQL Performance: Deep Dive into Query Execution, Indexes, and Optimization Strategies

This article explains MySQL's logical architecture, query processing steps, client/server protocol, query cache behavior, parsing, optimizer cost model, execution engine, result delivery, and provides practical performance‑tuning advice on schema design, index creation, and specific query patterns.

Database ArchitectureMySQLQuery Optimization
0 likes · 36 min read
Unlock MySQL Performance: Deep Dive into Query Execution, Indexes, and Optimization Strategies
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.

MySQLOracleSQL
0 likes · 8 min read
How to Slash SQL I/O and CPU Costs: Practical Query Performance Tips
21CTO
21CTO
Aug 14, 2017 · Databases

Master MySQL Performance: Using EXPLAIN, Indexes, and Slow Query Analysis

This guide explains how to analyze MySQL performance with EXPLAIN statements, composite indexes, slow‑query logging, storage engine locking differences, and transaction settings, providing practical examples and detailed descriptions of each EXPLAIN output column.

EXPLAINMySQLSlow Query
0 likes · 7 min read
Master MySQL Performance: Using EXPLAIN, Indexes, and Slow Query Analysis
ITPUB
ITPUB
Jun 7, 2017 · Databases

Top 38 Oracle SQL Performance Tips for Faster Queries

This article compiles 38 practical Oracle SQL tuning techniques—from ordering tables and rewriting WHERE clauses to using indexes, avoiding SELECT *, leveraging DECODE, replacing HAVING with WHERE, and preferring TRUNCATE over DELETE—each illustrated with clear examples to help developers write faster, more efficient queries.

DatabaseOracleQuery Writing
0 likes · 23 min read
Top 38 Oracle SQL Performance Tips for Faster Queries
ITPUB
ITPUB
Mar 18, 2017 · Databases

Mastering SQL Server Aggregate Functions: Optimization Tips and Techniques

This article explains SQL Server aggregate functions, detailing scalar and hash aggregation concepts, demonstrates execution‑plan analysis with COUNT examples, and provides practical optimization techniques such as avoiding sorting and adding non‑clustered indexes, while also covering monitoring metrics for performance tuning.

SQL ServerScalar Aggregationaggregate functions
0 likes · 9 min read
Mastering SQL Server Aggregate Functions: Optimization Tips and Techniques
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.

Query OptimizationSQL ServerTemp Tables
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 OrderQuery OptimizationSQL Server
0 likes · 16 min read
Mastering SQL Server: Understanding Query Execution Order and Optimization Tips
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 DesignJoinsQuery Optimization
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 DesignQuery OptimizationSQL
0 likes · 11 min read
Essential Database Design and Query Optimization Tips for Faster SQL Performance
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.

Query OptimizationSQLdatabase tuning
0 likes · 11 min read
SQL Query Optimization Tips and Best Practices
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.

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

34 Proven Oracle SQL Tricks to Boost Query Performance

This guide compiles 34 practical Oracle SQL optimization techniques—from selecting the optimal table order and rewriting WHERE clauses to leveraging indexes, avoiding costly operators, and fine‑tuning execution plans—helping developers dramatically reduce query execution time and resource consumption.

DatabaseOptimizationOracle
0 likes · 19 min read
34 Proven Oracle SQL Tricks to Boost Query Performance
ITPUB
ITPUB
Oct 9, 2016 · Databases

Master MySQL Data Types and Indexes to Boost Performance

This guide explains MySQL's numeric, temporal, and string data types, their storage implications, and how to choose appropriate types, while detailing index types, creation rules, and optimization tips such as prefix lengths and B+Tree versus HASH strategies for faster queries.

Data TypesInnoDBMySQL
0 likes · 11 min read
Master MySQL Data Types and Indexes to Boost Performance
MaGe Linux Operations
MaGe Linux Operations
Sep 17, 2016 · Databases

Master MySQL Field Types, Indexes, and EXPLAIN for Faster Queries

This guide outlines practical recommendations for selecting MySQL field types, optimizing indexes, interpreting EXPLAIN output, and understanding its limitations, helping developers design efficient schemas and improve query performance while also highlighting common pitfalls such as misuse of NULL columns and inappropriate enum expansions.

EXPLAINField TypesMySQL
0 likes · 10 min read
Master MySQL Field Types, Indexes, and EXPLAIN for Faster Queries
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.

Query OptimizationSQLindexes
0 likes · 11 min read
30 Essential SQL Query Optimization Tips to Avoid Full Table Scans
ITPUB
ITPUB
Jul 28, 2016 · Databases

Oracle SQL Tuning Essentials: Joins, Execution Plans, CBO vs RBO, Backup Tips

This guide provides comprehensive Oracle database interview questions and answers covering SQL tuning techniques such as join types, execution‑plan inspection, CBO vs RBO, heavy‑SQL identification, session tracing, index structures, binding variables, plan stability, memory settings, tablespace management, backup and recovery methods including RMAN and standby, as well as system performance diagnostics.

CBOOraclePerformance Diagnosis
0 likes · 19 min read
Oracle SQL Tuning Essentials: Joins, Execution Plans, CBO vs RBO, Backup Tips
ITPUB
ITPUB
Jul 24, 2016 · Databases

10 Proven Techniques to Supercharge Your Database Performance

Learn ten practical strategies—from careful schema design and precise SELECT statements to query caching, index creation, and smart use of JOINs, LIMIT, UNION, and wildcards—that dramatically improve database speed and reduce server load on high‑traffic websites.

Query DesignSQLcaching
0 likes · 9 min read
10 Proven Techniques to Supercharge Your Database Performance
ITPUB
ITPUB
Jul 8, 2016 · Databases

Boost Oracle Insert Speed by Moving Hourly Indexes to Memory and Fixing Offline Datafile Issues

The article describes a step‑by‑step experiment that moves hourly partitioned indexes into memory on Oracle 12c to boost insert performance, then details the unexpected issue of offline index datafiles causing rebuild failures, and explains how to work around the problem by adjusting tablespaces and handling temporary segments.

OracleTablespacesindexes
0 likes · 10 min read
Boost Oracle Insert Speed by Moving Hourly Indexes to Memory and Fixing Offline Datafile Issues
Practical DevOps Architecture
Practical DevOps Architecture
Jun 20, 2016 · Databases

MySQL Performance Tuning Guide: Architecture, System, MySQL Settings, and Application Optimizations

This guide outlines comprehensive MySQL performance tuning techniques, covering architectural replication, system‑level hardware adjustments, MySQL configuration parameters, and application‑level query optimizations with specific recommended values for buffers, caches, and connection limits.

BuffersMySQLdatabase optimization
0 likes · 6 min read
MySQL Performance Tuning Guide: Architecture, System, MySQL Settings, and Application Optimizations
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.

DatabaseQuery OptimizationSQL Server
0 likes · 21 min read
Top 50 SQL Server Query Optimization Tips to Boost Performance
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.

JoinsOracleSQL
0 likes · 8 min read
Practical Tips for Optimizing Oracle SQL Execution Plans
dbaplus Community
dbaplus Community
Feb 3, 2016 · Databases

What Makes PostgreSQL Superior? Data Types, Indexes, and Queries Compared

This article examines why PostgreSQL claims to be the most advanced open‑source database by detailing its object‑relational model, extensive native data types, large‑scale size limits, robust ACID compliance, powerful indexing options, flexible virtual table features, built‑in functions, language extensions, and how these capabilities compare to MySQL, MariaDB and Firebird.

CTEData TypesDatabase Comparison
0 likes · 21 min read
What Makes PostgreSQL Superior? Data Types, Indexes, and Queries Compared
dbaplus Community
dbaplus Community
Dec 2, 2015 · Databases

Mastering DB2 Indexes, Predicates, and Runtime Architecture

This article explains DB2's B+‑tree index structure, the difference between Indexable and Sargable predicates, how the DB2 runtime components (BM, IM, DM, RDS) process queries, and practical tips for writing efficient predicates and choosing scan strategies.

DB2Matching ScanPredicates
0 likes · 10 min read
Mastering DB2 Indexes, Predicates, and Runtime Architecture
Architect
Architect
Aug 26, 2015 · Databases

Understanding B-Tree and Hash Indexes in MySQL

This article explains the characteristics and usage scenarios of B-Tree and Hash indexes in MySQL, including supported operators, example queries, when indexes are applied or ignored, and performance considerations for different storage engines such as MEMORY.

B+TreeHash IndexMySQL
0 likes · 6 min read
Understanding B-Tree and Hash Indexes in MySQL
Qunar Tech Salon
Qunar Tech Salon
May 3, 2015 · Databases

Optimizing PostgreSQL Queries for Flight Data Retrieval at Qunar

The article analyzes a slow PostgreSQL query that joins multiple tables to fetch flight numbers, compares several alternative query formulations with their execution plans, and presents a final solution using array aggregation to achieve sub‑millisecond performance despite existing indexes.

Database PerformancePostgreSQLQuery Optimization
0 likes · 7 min read
Optimizing PostgreSQL Queries for Flight Data Retrieval at Qunar
ITPUB
ITPUB
Oct 20, 2014 · Databases

Why Indexes Are the Key to Cutting Logical Reads and Speeding Up SQL

The article explains how inefficient SQL statements increase logical reads, why creating effective indexes dramatically reduces those reads and execution time, and discusses practical guidelines for choosing indexed columns, differences between clustered and non‑clustered indexes, and common pitfalls in index design.

Logical ReadsSQLindexes
0 likes · 5 min read
Why Indexes Are the Key to Cutting Logical Reads and Speeding Up SQL
MaGe Linux Operations
MaGe Linux Operations
Aug 8, 2014 · Databases

Master MongoDB Indexes: Query Plans, Creation, and Optimization Tips

This guide walks through MongoDB index fundamentals, showing how to view query plans, create single and compound indexes, manage index types like unique, sparse, and multikey, force specific indexes or full scans, and handle in‑memory sorting and index management for optimal performance.

DatabaseMongoDBQuery Optimization
0 likes · 6 min read
Master MongoDB Indexes: Query Plans, Creation, and Optimization Tips