Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Index rebuilds
Oracle 8.0.5. Can index rebuilds be used on a table that has
been truncated and reloaded? In other words, we have a table
and then we truncate it and load it with much of the same data,
except more data (don't ask me why they do it this way). Can
we have an index, truncate the table, then just do a rebuild?
We want to be able to save time with the indexes and also be
able to change storage parameters.