Re: 8.1.7 Cursor resource usage vs Table data type resource usage?

From: Daniel Roy <danielroy10_at_hotmail.com>
Date: 4 Apr 2003 08:57:49 -0800
Message-ID: <1b061893.0304040857.4b206f0b@posting.google.com>

Tom Kyte seems to agree with you, according to his post at http://asktom.oracle.com/pls/ask/f?p=4950:8:1287113953499555::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1363403159158,

Daniel

ouckie_at_yahoo.com (Gavin) wrote in message news:<9352287d.0304031235.4c64b5d0_at_posting.google.com>...
> I am trying to determine which would use more resources - a cursor or
> a table data type.
>
> I find the table data type faster. Would this be because it is all in
> memory where a cursor is not placed all in memory?
>
> Why would I want to use a cursor when I can bulk collect into a table
> data type?
>
> Thanks
>
> Gavin
Received on Fri Apr 04 2003 - 10:57:49 CST