gt; Subject: Re: [PERFORM] Sequencial scan in a JOIN
>
> On 06/05/2012 07:48 AM, Andrew Jaimes wrote:
>
> > ' -> Hash Join (cost=10.93..99795.09 rows=242803 width=0) (actual
> > time=0.541..2249.027 rows=33 loops=1)'
> > 'Hash Con
Hi everyone,
I am trying to run the following query:
SELECT count(1) --DISTINCT l_userqueue.queueid
FROM e_usersessions
JOIN l_userqueue
ON l_userqueue.userid = e_usersessions.entityid
JOIN a_activity
ON a_activity.activequeueid = l_userqueue.queueid
AND a_activity.vstatus
