Incremental load and indexes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sirvinay@gmail.com - 31 Mar 2006 13:27 GMT

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

Reply to this Message

Anurag Varma - 31 Mar 2006 14:10 GMT

By telepathy! Oracle server will understand your motives and
automatically add the new rows to indexes. Try it!

And yes, when you get the chance read this:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c11schem.htm#3239

Reply to this Message