HI Guys,
I needed to know - which is faster a select query or cursor
In the Pl/sql procedure?
Thanks.
GD_1976,
Printable View
HI Guys,
I needed to know - which is faster a select query or cursor
In the Pl/sql procedure?
Thanks.
GD_1976,
I would guess that a single SELECT statement would be faster than a cursor because there would be more overhead managing the cursor.
Setup a test and time them both. That would be the easiest way...
HI Jeff,
How do you set up the testing ?
Can you be more specific about that?
GD_1976.
I don't think there would be much difference - all SQL statements in Oracle are implemented either explicitly or implicitly as cursors.
to test use dbms_utility.get_time, put it in your pl/sql procedure and dbms_output it