Auto update stats not good enough

  • Just a thought but does anyone know if using Deleted bits instead of actually deleting help with the stats and index fragmentation?

  • It will, as long as there are no stats or indexes on that column. But marking a row as deleted will probably result in that "mark" column being indexed because it will be highly used to differentiate between a valid record and a "deleted" record.

    In our case, that would not be a good idea because users are free to reprocesss any period any number of times(And they do) and we will end up generating a humongous amount of rows, which will present it's own challenges in terms of maintenance and query efficiency.

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply