Hi master Gunneyk,
Thank you very much for reply.
I'm upgrading to 2005 because the policy of my company (we work for the government) says that we can only upgrade to a new engine when it as the SP3 released, because of bogs that can can appear.
so, we will upgrade to 2008 wen SP3 for this engine is released, until then, it's 2005.
Sorry to put so much questions about Stats and Indexs, but i still have some doughts about it.
1) i was talking to a guy about this upgrade and he told me that if i make this command:
UPDATE STATISTICS table_name WITH FULLSCAN
That my table would be updated with the correct statistics.
i'm thinking in using this command to do the update to statistics.
But i have to execute one comand for each table and index in the database. This will take me much time to build the script.
Is there a way of, in a single command, update the entire statistics to the new values that we want?
2) Other question that i have is this:
I understud from your post, that if i make the rebuild of an index, then i don't need to update it's statistics, because the rebuild process will do also the update to the statistics of that index. is this correct?
3) If the anwser is yes, i still have other question:
what are the objects in a database that have statistics and therefour have to see them updated?
It's only the indexes and the tables?
4) If the objects that i have to update statitcs are tables and indexs , other question that i have is this:
If i rebuild the indexs , i will no need to update statistics for this objects, but i still have to make update the all the tables (it's statistis) correct?
thank you master,