OraFAQ Forum: SQL & PL/SQL » Whether to use Cursors or Update Queries

Home » SQL & PL/SQL » SQL & PL/SQL » Whether to use Cursors or Update Queries

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Whether to use Cursors or Update Queries [message #39990]

Mon, 02 September 2002 03:54

Ganesh babu
Messages: 2
Registered: September 2002

Junior Member

Hi,

I am having One Problem. I have to Update one table using the datas in the other table.
for that i am using Query. i want to know whether it will slow down if i am having more records. i heard that usage of cursors will take servers space. so which one is best method. whether to use cursors or correlated update queries.

Yours

Ganesh

Report message to a moderator

Re: Whether to use Cursors or Update Queries [message #39994 is a reply to message #39990]

Mon, 02 September 2002 12:39

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

A single update (using a correlated subquery) is always the best choice. Only use a cursor based update with a periodic commit frequency if your rollback segments are not sized correctly for your transactions.

Report message to a moderator

Previous Topic:	query optimisation
Next Topic:	2 tables, different formats, extract to csv.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 08:35:20 CDT 2024