BestHub
search
Sign in
Tag

non-clustered index

1 views collected around this technical thread.

Python Programming Learning Circle
Python Programming Learning Circle
Mar 18, 2021 · Databases

Performance Comparison of Clustered and Non-Clustered Indexes in SQL Server and MySQL

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.

DatabaseIndexingMySQL
0 likes · 7 min read
Performance Comparison of Clustered and Non-Clustered Indexes in SQL Server and MySQL
Architecture Digest
Architecture Digest
Nov 6, 2019 · Databases

Understanding MySQL Indexes: From Binary Search Trees to B+ Trees and Their Use in InnoDB

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-TreeDatabaseIndex
0 likes · 14 min read
Understanding MySQL Indexes: From Binary Search Trees to B+ Trees and Their Use in InnoDB