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
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