Viewing 4 posts - 1 through 4 (of 4 total)
The most critical tables are the large fact tables in the DWH. These have a clustered (primary key) index and additional non-clustered indexes on foreign keys. Based on your answer,...
November 26, 2007 at 1:27 am
Marek Powichrowski (11/22/2007)
vebjornwa (11/22/2007)
All indexes are fully operational after truncation and during inserts/data transfer, which is what makes me suspect the index rebuild is not needed.
Yes, I think the same....
November 22, 2007 at 4:52 am
All indexes are fully operational after truncation and during inserts/data transfer, which is what makes me suspect the index rebuild is not needed.
For the record: I have not developed these...
November 22, 2007 at 4:28 am
Marek Powichrowski (11/22/2007)
Your package do the following tasks:1. Truncate,
2. Transfer data
3. Reindex.
Is your package works this way?
Yes, correct. And the question is if reindexing is just waste of time.
November 22, 2007 at 3:37 am
Viewing 4 posts - 1 through 4 (of 4 total)