AnsweredAssumed Answered

Clustered Indexes on QOS tables

Question asked by JeffRosenzweig62353713 on Mar 5, 2009
Latest reply on Mar 7, 2009 by JeffRosenzweig62353713
I noticed that the QOS tables (HN*,RN*) in our production environment have Clustered Indexes on the table_id and sampletime fields, but when I look at an old development Nimbus database that we have, there aren't any indexes on these tables. In our environment these tables are a high write/low read volume. We run a job everynight to defrag these indexes, but halfway through the day they end up being fragged again. Do you guys have any recommendation for lowering the rate of fragmentation?