How do I optimize this? - Mailing list pgsql-sql

From Wei Weng
Subject How do I optimize this?
Date
Msg-id 49C0198B.2050304@kencast.com
Whole thread Raw
Responses Re: How do I optimize this?
List pgsql-sql
Hi all.

I have the following scenario:

A table T (int t1; int t2; ... int t10; int tkey)
A table D (int da; int db),

And I have the following query
update T set t1 = b.aa FROM (select COUNT(1) as aa FROM D WHERE D.da = 
<count>) as b where tkey = <value>;
update T set t2 = b.aa FROM (select COUNT(1) as aa FROM D WHERE D.da = 
<count>) as b where tkey = <value>;
...
update T set t10 = b.aa FROM (select COUNT(1) as aa FROM D WHERE D.da = 
<count>) as b where tkey = <value>;

The queries are run on the same <value>. Is there anyway to optimize this???


Thanks
Wei





pgsql-sql by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: join
Next
From: Wei Weng
Date:
Subject: Re: How do I optimize this?