Very Computer

Hi Everyone,
I have three transaction tables in one of my databases where the primary
keys are clustered indexes.
At the end of every day, the scan density ( from DBCC SHOWCONTIG output)
become low ( around 15% ).
I am using DBCC DBREINDEX (table_name) to make it 100%. The next day, after
many transactions ( INSERT, UPDATE,DELETE) the scan density became 15%.
Is this a normal thing?
If it is normal, Should I schedule a task to do REINDEXing for me?

Thanks for your help in advance.

--
Tareq Lootah

Tareq,

You could use a fillfactor, so that your pages aren't totally flled when
you rebuild your indexes.
I don't know if this applies to you, but I'd check if the PK really is the
best candidate for your clustered index.
--

MCSE, MCSD, MCT, SQL Server MVP
Cornerstone Sweden AB

Tareq,

 Depending on how many page-splits you are doing, then yes, it is
possible to fragment the table this much.  If your app needs to do a
lot of scanning, then as you have suggested, REINDEX will help.

 Neil Pike MVP/MCSE
 Protech Computing Ltd (MS Solution Provider)