Unix Technical Forum

Incremental load and indexes

This is a discussion on Incremental load and indexes within the Oracle Miscellaneous forums, part of the Oracle Database category; --> We have been doing a full refresh of a huge table it takes around 4 hours usually. we truncate ...


Go Back   Unix Technical Forum > Database Server Software > Oracle Database > Oracle Miscellaneous

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-08-2008, 10:07 AM
sirvinay@gmail.com
 
Posts: n/a
Default 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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-08-2008, 10:07 AM
Anurag Varma
 
Posts: n/a
Default Re: Incremental load and indexes


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...schem.htm#3239

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 06:16 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com