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

.

Relevant Pages

  • Re: Indexing problem with Make Table query and Create Index code (repost)
    ... Allen Browne - Microsoft MVP. ... It makes no difference how I relink - whether I delete and recreate - or ... And this happens even if I don't then refresh the links to ... table), and recreate it? ...
    (comp.databases.ms-access)
  • Re: Indexing problem with Make Table query and Create Index code (repost)
    ... It makes no difference how I relink - whether I delete and recreate - or just refresh. ... There appears to be something strange in the table creation process that causes the problem. ...
    (comp.databases.ms-access)
  • Re: refresh button help
    ... When you hit the "refresh" button, the browser need to resend the form's ... To prevent this you can add a button to the webform that recreate the ... i have a simple web form with a gridview and a button. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: How to Refresh with VBA(SQL) created Pivot
    ... > I understand that will recreate the sheet and the pivottable, ... > it so that other pivottables that use the same source can be refreshed ... After creating a pivottable using your code, to refresh, recreate your ... Set objPivotCache = ActiveWorkbook.PivotCaches ...
    (microsoft.public.excel.programming)
  • Creating Rpm database
    ... in rpm directory. ... How can I recreate it? ... I donot know how I lost the whole directory and ... Iam missing rpmpkgs file also. ...
    (RedHat)