#Sql-Indexes

Solving Bottlenecks With SQL Indexes and Partitions

Explains when SQL indexes help range queries, when wildcards defeat them, how B-tree depth and fragmentation affect reads, and how partitioning changes maintenance and query plans.