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

I am a NOVICE .
[Quoted] 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. Received on Wed Dec 07 2005 - 17:25:21 CET