A column that counts the number of index entries on a specific index?
View Single Post
06-07-2012, 05:06 PM
Right. Those are bad for this because they require too much maintenance. You'll have to have one when posts are added, deleted, or moved. Furthermore if the trigger should for some reason fail you'll have to recompile all your data to make it valid again. Preforming counts on the spot requires no maintenance and has less ways to fail.
View Public Profile
Find More Posts by Village Genius