P
Paul Koufalis
Guest
That 20% is applicable at the table level more than the DB level, I would think. Customer and item are unlikely to change 20% very often but inventory, shipper, invoice, gl...all those tables are constantly being modified. (Theoretically) I wonder if basing the decision on index operations (_IndexStat) would give a more precise trigger. A table that has x amount of write activity to indexes is potentially in need of an UPDATE STATISTICS. But you are correct, you script it once and forget about it. I think monthly is more than sufficient but as you say, weekly does no harm and you are probably running other maintenance tasks weekly anyways. Paul
Continue reading...
Continue reading...