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.