Persist Index Usage Statistics
During a database/application performance investigation we wanted to check which indexes were being used. The database had almost 1,200 indexes (!!) most of which we believed were redundant or partly causing a performance overhead. A quick review of the indexes showed that most were created on one column and only...
[Read More]