BestHub
Sign in
Tagged articles
23 articles
Page 1 of 1
Top Architect
Top Architect
Jan 18, 2026 · Databases

Boost Your SQL Query Speed: Proven Optimization Techniques

This guide walks through the SQL query processing workflow, explains how parsing, optimization, and execution plans affect performance, and provides concrete techniques—such as selecting specific columns, avoiding DISTINCT, using proper indexes, preferring EXISTS over COUNT, limiting result sets, and replacing HAVING with WHERE—to dramatically speed up queries while keeping statements concise.

Database PerformanceSQL Best Practicesindexes
0 likes · 8 min read
Boost Your SQL Query Speed: Proven Optimization Techniques
ITPUB
ITPUB
Apr 19, 2025 · Databases

Can SQL Run Tetris? Exploring a Recursive CTE Tetris Implementation

This article showcases a spectacular PostgreSQL query that implements the classic Tetris game using recursive CTEs, provides the full source code, highlights a known long‑run disk‑usage issue, and then presents several other impressive SQL snippets and a concise checklist for writing high‑quality SQL.

Database OptimizationSQL Best PracticesTetris
0 likes · 25 min read
Can SQL Run Tetris? Exploring a Recursive CTE Tetris Implementation
Su San Talks Tech
Su San Talks Tech
Oct 12, 2024 · Databases

Master MySQL: Essential Database Design and Performance Guidelines

This article compiles comprehensive MySQL best‑practice guidelines covering charset selection, storage engine choice, naming conventions, field design, index optimization, SQL development tips, and operational procedures to improve performance, maintainability, and reliability of database systems.

SQL Best Practicesdata modelingindexing
0 likes · 23 min read
Master MySQL: Essential Database Design and Performance Guidelines
Su San Talks Tech
Su San Talks Tech
Apr 2, 2024 · Databases

18 Essential Tips for Designing Robust Database Tables

This article presents 18 practical guidelines for backend developers on naming conventions, field types, lengths, primary keys, indexes, storage engines, null constraints, foreign keys, character sets, collations, large fields, redundant fields, and comments to help create efficient, maintainable MySQL tables.

Database designSQL Best Practicesindexing
0 likes · 22 min read
18 Essential Tips for Designing Robust Database Tables
DataFunSummit
DataFunSummit
Feb 18, 2022 · Databases

ClickHouse Usage Guide: Application Scenarios, Table Engine Selection, Development Standards, Cluster Architecture, and Configuration

This comprehensive guide introduces ClickHouse as a high‑performance columnar DBMS, outlines its typical OLAP use cases, explains the four families of table engines with detailed MergeTree variants, provides SQL creation syntax, shares development and write best practices, and describes cluster architecture, Zookeeper role, chproxy, client tools, availability considerations, and key configuration parameters.

Cluster ArchitectureSQL Best PracticesTable Engines
0 likes · 22 min read
ClickHouse Usage Guide: Application Scenarios, Table Engine Selection, Development Standards, Cluster Architecture, and Configuration
ITPUB
ITPUB
Jun 21, 2021 · Databases

Mastering TiDB: Essential Naming, Design, and SQL Best Practices

This comprehensive guide provides TiDB developers and administrators with standardized naming conventions, object‑design principles, data‑model considerations, SQL development rules, transaction limits, implicit type‑conversion pitfalls, result‑set stability tips, index strategies, auto‑increment handling, timeout settings, JDBC configuration, hotspot mitigation, pagination techniques, and unique ID generation methods.

SQL Best PracticesTiDBTransaction Limits
0 likes · 53 min read
Mastering TiDB: Essential Naming, Design, and SQL Best Practices
Code Ape Tech Column
Code Ape Tech Column
Jan 26, 2021 · Databases

Why Adding LIMIT to MySQL DELETE Is a Must‑Have Safety Habit

The article explains why appending LIMIT to MySQL DELETE statements improves performance, reduces lock contention, and safeguards data by limiting rows affected, provides syntax details, compares deletion strategies for removing large numbers of rows, and offers practical recommendations for safe and efficient data removal.

DELETEData SafetyDatabase Performance
0 likes · 8 min read
Why Adding LIMIT to MySQL DELETE Is a Must‑Have Safety Habit
Efficient Ops
Efficient Ops
Jul 1, 2020 · Databases

Essential MySQL Naming, Design, and Indexing Standards for Reliable Databases

This guide outlines comprehensive MySQL best practices covering naming conventions, table engine and charset choices, field type selection, index design principles, common index column recommendations, ordering of composite indexes, avoidance of redundant and foreign‑key constraints, SQL development rules, and operational guidelines for large‑scale data handling.

Database designIndex OptimizationSQL Best Practices
0 likes · 21 min read
Essential MySQL Naming, Design, and Indexing Standards for Reliable Databases
Laravel Tech Community
Laravel Tech Community
May 7, 2020 · Databases

MySQL Database Naming, Design, Field, Index, and Operation Standards

This guide presents comprehensive MySQL best‑practice standards covering object naming, basic schema design, field definitions, index design, common index column recommendations, covering indexes, SET usage, SQL development rules, and safe operational behaviors to improve performance, maintainability, and security.

Database designSQL Best Practicesindexing
0 likes · 19 min read
MySQL Database Naming, Design, Field, Index, and Operation Standards
Laravel Tech Community
Laravel Tech Community
May 2, 2020 · Databases

MySQL Database Naming, Design, Indexing, and Development Standards

This comprehensive guide outlines MySQL database naming conventions, basic design rules, field specifications, index design principles, common index recommendations, and best practices for SQL development and operational behavior to ensure performance, maintainability, and security.

Database designSQL Best Practicesindexing
0 likes · 18 min read
MySQL Database Naming, Design, Indexing, and Development Standards
Liangxu Linux
Liangxu Linux
Feb 10, 2020 · Databases

Master MySQL: Essential Naming, Design, and Indexing Standards

This guide presents comprehensive MySQL best‑practice rules covering object naming conventions, fundamental schema design, field type selection, index creation strategies, and SQL development habits to improve performance, maintainability, and reliability of production databases.

Database designSQL Best Practicesindexing
0 likes · 19 min read
Master MySQL: Essential Naming, Design, and Indexing Standards
ITPUB
ITPUB
Aug 23, 2019 · Databases

Essential MySQL Database Design and Indexing Best Practices

This guide compiles comprehensive MySQL conventions covering object naming, storage engine choices, character sets, table and column design, indexing strategies, query optimization, and operational safeguards to improve performance, maintainability, and data integrity in production environments.

Database designSQL Best Practicesindexing
0 likes · 19 min read
Essential MySQL Database Design and Indexing Best Practices
Architect's Tech Stack
Architect's Tech Stack
Jul 25, 2019 · Databases

Database Command and Design Standards

The article outlines comprehensive MySQL database standards covering naming conventions, table and column design, index strategies, SQL development practices, and operational guidelines to improve performance, maintainability, and security, including recommendations on data types, character sets, reserved fields, binary data storage, and safe query patterns.

SQL Best Practicesdatabaseindex design
0 likes · 21 min read
Database Command and Design Standards
Architecture Digest
Architecture Digest
Apr 18, 2019 · Databases

MySQL High Performance Optimization Guidelines and Best Practices

This article presents a comprehensive set of MySQL high‑performance optimization guidelines, covering naming conventions, table design, data types, index strategies, SQL coding standards, replication, backup, and operational best practices to improve efficiency, reliability, and scalability of database systems.

Database designOperationsSQL Best Practices
0 likes · 19 min read
MySQL High Performance Optimization Guidelines and Best Practices
Efficient Ops
Efficient Ops
Mar 12, 2019 · Databases

Master MySQL: Essential Naming, Design, and Indexing Standards

This guide outlines comprehensive MySQL best practices, covering naming conventions, basic schema design, field type selection, index strategies, foreign‑key usage, SQL coding standards, batch operations, online schema changes, and permission principles to ensure performant and maintainable databases.

Database designSQL Best Practicesindexing
0 likes · 20 min read
Master MySQL: Essential Naming, Design, and Indexing Standards
Senior Brother's Insights
Senior Brother's Insights
Mar 12, 2019 · Databases

Essential MySQL Naming, Design, and Indexing Standards for Reliable Databases

This guide presents comprehensive MySQL best‑practice rules covering database object naming, basic schema design, column definitions, index creation, SQL coding conventions, and operational behaviors to improve maintainability, performance, and data integrity across development and production environments.

Naming ConventionSQL Best Practicesdatabase-design
0 likes · 20 min read
Essential MySQL Naming, Design, and Indexing Standards for Reliable Databases
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
dbaplus Community
dbaplus Community
Jan 15, 2019 · Databases

Essential MySQL Naming, Design, and Indexing Standards for Reliable Databases

This guide outlines comprehensive MySQL best‑practice rules covering object naming, table engine and charset choices, column design, index strategies, SQL coding conventions, and operational safeguards to improve performance, maintainability, and data integrity in production environments.

Database designSQL Best Practicesindexing
0 likes · 20 min read
Essential MySQL Naming, Design, and Indexing Standards for Reliable Databases
ITPUB
ITPUB
Jan 9, 2018 · Databases

Top 17 Oracle SQL Tuning Techniques to Boost Query Performance

This guide presents seventeen practical Oracle SQL optimization tips—including table order selection, WHERE clause ordering, avoiding SELECT *, reducing round‑trips, using DECODE, consolidating queries, eliminating duplicates, preferring TRUNCATE, leveraging COMMIT, replacing HAVING with WHERE, minimizing sub‑queries, employing internal functions, using aliases, favoring EXISTS over IN, detecting inefficient SQL, and proper index usage—to help developers write faster, more efficient database queries.

Database IndexesOracleQuery Planning
0 likes · 11 min read
Top 17 Oracle SQL Tuning Techniques to Boost Query Performance