[go] wild goose chase

[Seth Carbon]

I believe that this is the query that you want--since every bit of
evidence is going to belong to an association, there is no need for a
join. It also runs fairly quickly (30s):


SELECT evidence.code, count(*) AS evidence_count
FROM evidence
GROUP BY evidence.code;


Cheers,

-Seth


On Mon, 2007-11-05 at 12:57 -0800, Sue Rhee wrote:
> I've been trying to do a couple of SQLs using Goose and it's timing out.
> Can someone please run the following SQL for me please?
> 
> SELECT evidence.code, count(distinct association.id) AS
> evidence__association_count FROM association, evidence where
> evidence.association_id = association.id GROUP BY evidence.code
> 
> Thanks,
> Sue
> 
>