|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
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.