Does truncate and API Load invalidate statistics

As part of my data warehouse nightly build, I truncate my tables in my
target database.
As example, I find it is much quicker to do a bulk API load of 13M
records and to do an update/insert of 100K rows. I also drop the
indexes before the builds and reindex after. Thats an aside.
What I am wondering is how is this impacting the statistics? Do I need
to update them?
Not well versed on statistics and any data is welcomed.
Thanks
Robrcamarda (robc390@.hotmail.com) writes:

Quote:

Originally Posted by

As part of my data warehouse nightly build, I truncate my tables in my
target database.
As example, I find it is much quicker to do a bulk API load of 13M
records and to do an update/insert of 100K rows. I also drop the
indexes before the builds and reindex after. Thats an aside.
What I am wondering is how is this impacting the statistics? Do I need
to update them?

When an indexes added, statistics based a full scan is added for that
index, so you are fairly safe.

Would could matter is statistics of non-indexed columns. These you lose
when you truncate the tables. These statistics are less essential than
index on indexed columns, but there are queries where they may be useful.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Does the Report Manager use the RS WebService?

If the Report Manager uses the SOAP API to build the website, is there a way to find the code for this? This is a great working sample and I would like to see that code to help in my understanding and building of a proprietary site. There are a lot of snippets of code to show how to do things individually, but when you put them all together, it is very slow (Item Properties, Methods, etc.). //Report Mangaer does use the SOAP API to the Report Server web service, but we don't make the Report Manager source code publicly available.|||

Thanks for the response. If that is the case, I've been looking for good examples for retrieving the Report Name, Description and Parameters. When I piece together from other resources I can get it to work great! HOWEVER, it is very slow, especially the GetProperties Method!

Thanks.