February 11, 2005 at 8:39 am
Do you have to update usage and statistics on all tables on the database even though you reindex the whole database every night? Thanks
February 11, 2005 at 11:14 am
I was suppose to test this. Good now i will wait for the answer and do other projects
Amit Lohia
February 11, 2005 at 2:38 pm
When you rebuild indexes, the statistics do get recomputed. If you want to create indexes without rebuilding statistics, than you can use the create index statement with STATISTICS_NORECOMPUTE clause.
February 11, 2005 at 4:17 pm
Thanks for the input! I just have one more question to ask. If a vendor puts statistics on fields that are not indexed at all, do you still need to update the usage and statistics? Thanks for all your help.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply