>With the new possibilities of the Array, it comes natural,
>if the memory is available, to use them in intensive way.
>But the SELECT into Array however generate an intermediate cursor
>and then they copy this in the Array.
I don't find any convinvincing evidence supporting this hypothesis. My tests do show the creation of a new tmp file, however, its size (16Kb), was only about 2.5 tenths of 1% of the source table (6,163Kb). Further, the tmp file remained after the table was closed and the array released.
George
Ubi caritas et amor, deus ibi est