Houri Oracle Partitioned Index Efficiency PartitionedIndexEfficiency Although it is generally true that rebuilding an index represents a waste of time and resources, there nevertheless exist... 09 February 2017 10 min read
Jonathan Lewis Investigating Indexes – 2 In an earlier article on investigating indexes I described some methods for looking at the internal structure of an index... 09 January 2017 16 min read
Anju Garg Defragmentation Can Degrade Query Performance As data in tables is updated and / or deleted, pockets of empty space can be created, leading to fragmented... 16 June 2016 15 min read
Simple Talk Editorial Team SQL Server Performance Tuning Using Wait Statistics: A Beginner’s Guide This beginner's guide by Jonathan Kehayias and Erin Stellato covers the basics of using wait statistics; topics include the SQLOS... 01 April 2014 2 min read
