Re: For the GURUS - Load Process slowing down

From: Ozzy <ozzyknox_at_intekom.co.za>
Date: Tue, 6 Jul 1999 23:17:58 +0200
Message-ID: <7ltrqp$c5o$1@hermes.is.co.za>

Thanks, but I don't have any indexes on the load table, only on the destination online member table.

Ozzy

Satish wrote in message <37826c74_at_discussions>...
>
>If u are using SQL*Loader for loading with
>indexes active.. the time taken to load
>the huge volume of data is always more than
>the index inactive.. I have tested...or
>found out loading huge volume of data.. it
>happens b'cos each record or each rows it
>loads gets sorted out with the data that is
>available and loads the other or next record.
>So i always suggest is to load the data into
>the table completely and then add index to
>the table... (Specially complex index..i.e
>index for more than once column for a
>table)..
>
>Satish
>
>"Sinead" <kbsq_at_ziplink.net> wrote:
>>Have you looked into using Sql*Loader in
>Direct Path ? Rebuilding indexes>after load?
>Another suggestion is to remove indexes, run
>sql*loader then
>>add indexes after.
>>-
>>
>>
>>
>
Received on Tue Jul 06 1999 - 16:17:58 CDT