Re: Insert append and indexes

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 Received on Wed Apr 30 2003 - 13:06:51 CDT