Clarification on the affect of truncate on indexes
533669Feb 11 2008 — edited Feb 11 2008I want to be clear on this topic since we're changing a pattern of loading data.
If I truncate a table then reload it as part of a snapshot refresh are the indexes built prior to the truncate still valid or do they need to be dropped and recreated.
In the past I have always dropped indexes prior to a data load then rebuilt them at the completion. Mainly to speed the data load process but it always seemed that if you trunc and repopulate a table the indexes would be invalidated.
Am I correct or can I just leave those old indexes in place and not lose performance.
Thanks.
LP