Does truncate and API Load invalidate statistics

Giganews Newsgroups
Subject: Does truncate and API Load invalidate statistics
Posted by:  rcamarda (robc3…@hotmail.com)
Date: 16 Aug 2006

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
Rob

Replies