Re: BULK COLLECT - Can it be implemented for a few rows .
Date: 9 Dec 2005 14:33:04 -0800
Message-ID: <1134167584.519163.288260_at_g14g2000cwa.googlegroups.com>
[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