Re: Poor Query

From: Pierre-Frédéric Caillaud <lists(at)boutiquenumerique(dot)com>
To: "Pallav Kalva" <pkalva(at)deg(dot)cc>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Poor Query
Date: 2004-12-06 15:48:05
Message-ID: opsilfifducq72hf@musicbox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


How many rows do the following queries return :

select userID
from bankaccount ba
where ba.bankaccountID = u.bankaccountID
and ba.accountnumber = '12345678'

select userID
from bankaccount ba
where ba.bankaccountID = u.bankaccountID
and ba.routingNumber = '12345678'

Can you post EXPLAIN ANALYZE for these two queries ?
Regards.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Pallav Kalva 2004-12-06 15:52:51 Re: Poor Query
Previous Message Pallav Kalva 2004-12-06 15:28:23 Poor Query