Re: BULK COLLECT - Can it be implemented for a few rows .

Aravindh wrote:
> I am a NOVICE .
> Can you please tell me where to add the LIMIT clause ?
> The BULK COLLECT approach is behaving erratically . Sometimes it is
> running very fast ( 5 seconds for 5000 rows incremental load )
> and sometimes it is running slow (2 mins for 5000 rows incremental
> load ) .
>
> While the OLD procedure (the procedure which I pasted first) is running
> at the predetermined speed ( < 1 min for 5000 rows)
>
> Also can you please tell me whether we have to remove / delete the
> declared table type objects after the completion of the procdure .
>
> Also can you please tell us whether we have to boost some of the memory
> parameters while running the BULK COLLECT approach.

www.psoug.org
click on Morgan's Library
click on Bulk Binding
search for "LIMIT"

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)