From: Pierre-Frédéric Caillaud
Subject: Re: Poor Query
Date: ,
Msg-id: opsilfifducq72hf@musicbox
(view: Whole thread, Raw)
In response to: Poor Query  (Pallav Kalva)
Responses: Re: Poor Query  (Pallav Kalva)
List: pgsql-performance

Tree view

Poor Query  (Pallav Kalva, )
 Re: Poor Query  (Pierre-Frédéric Caillaud<>, )
  Re: Poor Query  (Pallav Kalva, )
   Re: Poor Query  (Pierre-Frédéric Caillaud<>, )
    Re: Poor Query  (Pallav Kalva, )
     Re: Poor Query  (Pierre-Frédéric Caillaud<>, )
      Re: Poor Query  (Pallav Kalva, )
       Re: Poor Query  (Pierre-Frédéric Caillaud<>, )
        Re: Poor Query  (Pallav Kalva, )

    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.


pgsql-performance by date:

From: Pallav Kalva
Date:
Subject: Re: Poor Query
From: "Rosny"
Date:
Subject: Re: TableSpace Design issues on Postgres 8.0 beta 5