Re: For the GURUS - Load Process slowing down

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:52:04 CDT