|
|
Posted by kmounkhaty@yahoo.com on 10/13/05 22:04
Hi guru,
I've been new company for only a month and started analysing Index
Fragmentation.
After I ran DBCC DBREINDEX and capture data into permanent table, I 've
seen lots of tables with no indexes. These tables showed:
Very low scan density,
High extent fragmentation
High Avg. Bytes Free per Page
What are the best strategies to defragment tables with no indexes?
I'm planning to make a rule that each table must have a clustered index
and this index must be created on the best column (highest
selectivity).
Please help.
Thanks,
Silaphet,
Navigation:
[Reply to this message]
|