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

Aravindh wrote:
> 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

Reducing disk reads is not a simple ... just do this ... kind of thing. Send me the SQL statement off-line at my email address below.

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