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

[Quoted] Dear Daniel A Morgan,

Thank you very much for your (previous mail )mail on LIMIT clause . As I said earlier I am a very amateur programmer and I am very new to ORACLE 9 i

When you said about LIMIT Clause I misunderstood that to the ROW_NUM and thought LIMIT 1000 will fetch only 1000 rows at a time . Sorry for my misunderstanding . Now I have very well understood the use of LIMIT clause and I shall deploy it perfectly well.

I also understood the reason for my proc failing for 1 million rows (NOT USING THE LIMIT clause)

But I do feel bad because the procedure has moved to the PRODUCTION environment BEFORE i realised the importance of LIMIT clause .

I shall be implementing the limit clause in the next move .

Also I have to reduce the DISK reads for the incremental approach . That was the ORIGINAL requirement. Thats why i resorted to the BULK COLLECT approach (thinking that the DISK READS would reduce ) . Is the BULK COLLECT approach adviseable for decreasing the disk reads ?  (or) can I start from the scratch by redesigning the old procedure.

I am not able to understand your previous mail since it is too difficult for me to comprehend . Can you please tell me some methods to reduce the DISK READS in the proc to an amateur like me so that I would be able to learn it and deploy effectively.

Thank you very much for your time and effort

Thanks
KN Aravindh Received on Fri Dec 09 2005 - 23:33:04 CET