Home » RDBMS Server » Performance Tuning » Avoiding Cursors.
Avoiding Cursors. [message #116842] Fri, 22 April 2005 08:55 Go to next message
krajdba
Messages: 2
Registered: April 2005
Location: Hyderabad
Junior Member

Hi


Please let me know different ways that we can use to avoid the Usage of Cursors.


Thanks,

Raj.
Re: Avoiding Cursors. [message #116851 is a reply to message #116842] Fri, 22 April 2005 09:16 Go to previous messageGo to next message
Frank Naude
Messages: 4565
Registered: April 1998
Senior Member
Hi,

The best way would be to stop running queries. All queries use cursors implicitly or explicitly.

That said, watch out that you don't do multiple selects when only one is required. For example:

Rather do -
SELECT SYSDATE, USERNAME FROM dual;


than -
SELECT SYSDATE FROM dual;
SELECT USERNAME FROM dual;


Best regards.

Frank
Re: Avoiding Cursors. [message #116853 is a reply to message #116842] Fri, 22 April 2005 09:21 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
Ha! Frank, you took the words out of my mouth on this one.

Just get rid of the data...no data, no queries, no cursors, and talk about the performance improvement!
Previous Topic: tuning question
Next Topic: help on network application information
Goto Forum:
  


Current Time: Sat Sep 19 01:12:05 CDT 2020