Insert append and indexes

I am using Oracle 8.1.7 and to speed up a data load from a remote server I am using the NOLOGGING option on the target tables and using the /* +append */ hint like this: Insert /* +append */ into table1 select from table2_at_remotesitedbalinked ( i use this to build 2 staging tables which will be joined to populate a third one in the next stage of my process)

If I build indexes on the target tables( to help the join needed in the next stage) what impact will that have on the load time and/or the validity of the indexes ( the tables will be truncated before the insert stage) ?

Thanks,

John

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Wed Apr 30 2003 - 10:06:08 CDT