Re: Insert append and indexes

Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote:

>On Wed, 30 Apr 2003 10:06:08 -0500, TurkBear
><john.greco_at_dot.state.mn.us> wrote:
>
>>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
>
>
>
>The indexes will be invalid after the load due to the append option
>
>
>>---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---
>
>Sybrand Bakker, Senior Oracle DBA
>
>To reply remove -verwijderdit from my e-mail address
Thanks Sybrand, I suspected as much, so I might as well drop first then recreate after the load...

----== 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 - 14:19:57 CDT