Re: [GENERAL] update queries taking lot of time

2005-02-24 Thread Dann Corbit
Subject: [GENERAL] update queries taking lot of time Hi, I am running update query of the form "update tablename set x = y where exists (select .)" These queries are taking lots of time. I dropped all indices on the table which provided some improvement but not remarkable perform

[GENERAL] update queries taking lot of time

2005-02-24 Thread vinita bansal
Hi, I am running update query of the form "update tablename set x = y where exists (select .)" These queries are taking lots of time. I dropped all indices on the table which provided some improvement but not remarkable performance. I am looking for ways to improve it. Can someone suggest wh