Could you help me understand the results of running sys.dm_db_index_physical_stats? select top 10 * from sys.dm_db_index_physical_stats(db_id('web_db1'), OBJECT_ID('tblUser'), NULL, NULL, 'DETAILED');
I see this table. Two HEAP indexes seem to have issues. Shall I simply rebuild the index for this table. How may I convert a table to have a clustered index if it has lots of transactions?
obj_id | avgFrag% | frag_cnt | avgFragPages | avgPageSpace% | recCnt | index_type
21575115 0 1 1 19.25 18 HEAP
21575115 0 1 1 3.31 18 NONCLUSTERED INDEX
47339233 68.21 122 9.06 94.6 222716 HEAP
47339233 0 19 26.16 99.63 222716 NONCLUSTERED INDEX
47339233 0 1 2 73.66 497 NONCLUSTERED INDEX
47339233 0 1 1 0.57 2 NONCLUSTERED INDEX
47339233 0 21 24.9 99.94 222716 NONCLUSTERED INDEX
47339233 0 1 2 80.74 523 NONCLUSTERED INDEX
47339233 0 1 1 0.59 2 NONCLUSTERED INDEX
53575229 33.33 5 19.2 98.96 23306 HEAP
Reading results from sys.dm_db_index_physical_stat
Posted - 03/06/2007 : 13:04:19
