Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Incremental load and indexes

Incremental load and indexes

From: <sirvinay_at_gmail.com>
Date: 31 Mar 2006 04:27:39 -0800
Message-ID: <1143808059.297838.204130@v46g2000cwv.googlegroups.com> 





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












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US