Re: [PERFORM] Poor Query

[Pierre-Frédéric Caillaud]

    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.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster