Afficher un message
Vieux 07/03/2007, 18h03   #1
Jon
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Rebuilding tables indexes

Hello all,

I have a table that I've just ran DBCC SHOWCONTIG ('Containers') against,
the scan density is coming out as 20% which I understand is bad, as it should
be above 75%, now ran DBREINDEX and also dropped and rebuilt all 4 indexes,
re ran the above and it's still coming out at 20%. Why is that and how do i
fix it?

Also, all columns (5) are of type 'int'.

Thanks,

Jon

  Réponse avec citation
 
Page generated in 0,05400 seconds with 9 queries