Re: Poor Query - Mailing list 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.