Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Incremental load and indexes
We have been doing a full refresh of a huge table
it takes around 4 hours usually. we truncate the table and recreate the
indexes
Now, we are planning to go for an incremental refresh of the table
and iam thinking that recreating the indexes is not necessary
but iam not sure how iam going to index the newly added rows
Please suggest Received on Fri Mar 31 2006 - 06:27:39 CST