Re: BULK COLLECT INTO Question
From: Richard Kuhler <noone_at_nowhere.com>
Date: Mon, 12 Nov 2001 22:32:11 GMT
Message-ID: <L5YH7.33720$D5.12008849_at_typhoon.san.rr.com>
Date: Mon, 12 Nov 2001 22:32:11 GMT
Message-ID: <L5YH7.33720$D5.12008849_at_typhoon.san.rr.com>
Thomas Kyte wrote:
<snip>
> You don't use bulk collect -- you use a multi-set BUT -- it must be a SQL type
> -- not a plsql type.
<snip>
On the downside, this technique is considerably slower than 'bulk collect', uses more memory (presumably object overhead of some sort) and doesn't have an efficient way to fetch batches (e.g. 1,000 rows at a time). For example, I did a sample set of 100,000 rows using this mulit-set method versus bulk collect. Multi-set was about twice as slow and used 64% more memory.
Richard Received on Mon Nov 12 2001 - 23:32:11 CET