Tagged articles
Non-clustered Index
10 articles · Page 1 of 1
The article explains how database indexes act like a book's table of contents, reducing full‑table scans and disk I/O by using B+Tree structures, and compares clustered, non‑clustered, and covering indexes while highlighting their benefits and trade‑offs.
B+ TreeCovering IndexDatabase Performance
0 likes · 11 min read

This article explains MySQL index fundamentals, covering what indexes are, their advantages and drawbacks, underlying data structures such as hash tables and B‑/B+‑trees, and the classification of clustered, non‑clustered, primary, secondary, unique, prefix, and full‑text indexes, with practical SQL examples and diagrams.
B-TreeHash TableMySQL
0 likes · 9 min read

This article provides a comprehensive review of MySQL’s two primary index types—clustered (clustered index) and non‑clustered (non‑clustered index)—explaining their storage mechanisms, performance trade‑offs, typical use cases, and best‑practice guidelines for selecting the appropriate index in database design.
MySQLNon-clustered Indexclustered index
0 likes · 14 min read

This article explains what non‑clustered indexes are, how they are built on B+‑tree structures, their main characteristics, and the scenarios where they improve query performance in relational databases, including fast lookups, join optimization, sorting, and handling frequent data modifications.
B+ TreeDatabase IndexingNon-clustered Index
0 likes · 5 min read

This article explains the fundamental concepts of MySQL index structures, detailing how clustered (primary) indexes store data physically in order, how non‑clustered (secondary) indexes reference primary keys, and compares their performance implications and practical usage scenarios.
Database PerformanceIndexInnoDB
0 likes · 8 min read

This article provides a comprehensive deep‑dive into MySQL indexing, covering the definition, pros and cons, differences between clustered and non‑clustered indexes, InnoDB vs MyISAM implementations, B+Tree structure, capacity calculations, adaptive hash indexes, index pushdown optimization, and how to interpret EXPLAIN output to verify index usage.
Adaptive Hash IndexB+ TreeIndex Pushdown
0 likes · 18 min read

This article investigates how clustered and non‑clustered indexes affect query, insert, update, and delete performance in SQL Server 2008R2 and MySQL 5.5 using three test tables, presenting detailed timing results and concluding that clustered indexes are optimal for small datasets while indexes dramatically speed up queries in MySQL.
Non-clustered IndexSQL Serverclustered index
0 likes · 7 min read

This article explains the fundamentals of database indexing, detailing B‑Tree structures, the differences between clustered and non‑clustered indexes, their storage formats, and how they affect query, insert, and delete operations, including the concept of index covering.
B+ TreeIndex CoveringNon-clustered Index
0 likes · 15 min read

This article explains the fundamentals of MySQL indexing, tracing the evolution from binary search trees and balanced AVL trees to B‑trees and B+‑trees, and details how InnoDB implements clustered and non‑clustered indexes, including search processes and performance considerations.
B+ TreeIndexInnoDB
0 likes · 14 min read


ITPUBFeb 19, 2017 · Databases
The article recounts a performance bottleneck in a Windows service that processed only about 12 records per second, analyzes why a simple SELECT TOP 1 query without proper indexes caused 89 ms latency, and demonstrates step‑by‑step how adding appropriate clustered and non‑clustered indexes reduced the execution time to virtually zero, while also discussing broader indexing strategies and common LEFT JOIN pitfalls.
Index OptimizationNon-clustered IndexQuery Performance
0 likes · 9 min read
