Automatic Workload Driven Index Defragmentation

Summary: Introduces workload-driven, online range-based defragmentation of B-Tree indexes, avoiding whole-tree rewrites. Demonstrates low-overhead benefit tracking and policy-driven automatic defragmentation in SQL Server, enabling targeted I/O improvement with minimal DBA effort. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 10212
Venue: VLDB
Year: 2011
Pagerank: 4.4785896e-05
Overall Rank: 8,642 | 39.88%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
4,590	MB2: Decomposed Behavior Modeling for Self-Driving Database Management Systems	2021	SIGMOD	6.0620053e-05
9,232	AutoComp: Automated Data Compaction for Log-Structured Tables in Data Lakes	2025	SIGMOD	4.3690661e-05

Outgoing Citations (Sorted by Pagerank)

Showing 0 of 0 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
2,047	Automatically Indexing Millions of Databases in Microsoft Azure SQL Database	2019	SIGMOD	9.6920209e-05
8,767	Dynamic Indexability and Lower Bounds for Dynamic One-Dimensional Range Query Indexes	2009	PODS	4.456315e-05
8,655	Adaptive Hybrid Indexes	2022	SIGMOD	4.4739554e-05
1,488	On the Analysis of Indexing Schemes	1997	PODS	0.00011699446
1,524	Sorting And Indexing With Partitioned B-Trees	2003	CIDR	0.00011516282
4,386	Indexing on Modern Hardware: Hekaton and Beyond	2014	SIGMOD	6.2320098e-05
4,108	Cracking the Database Store	2005	CIDR	6.4440088e-05
237	An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server	1997	VLDB	0.00031726304
408	Database Cracking	2007	CIDR	0.00023953844
516	AutoAdmin "What-if" Index Analysis Utility	1998	SIGMOD	0.00021196031