From: Pierre-Frédéric Caillaud
Subject: Re: Poor Query
Date: ,
Msg-id: opsilgs8b4cq72hf@musicbox
(view: Whole thread, Raw)
In response to: Re: 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, )


    Just wanted to know the selectivity of the accountnumber and
routingNumber columns.
    I shoulda written :

>>     How many rows do the following queries return :
    One or few at most, or a lot ?
>>
>> select userID
>>              from bankaccount
>>              WHERE accountnumber = '12345678'
>>
>> select userID
>>           from bankaccount
>>           WHERE routingNumber = '12345678'
>>
>>     Can you post EXPLAIN ANALYZE for these two queries ?
>>     Regards.
>>
> Thanks! for the quick reply. It should usually return just one account
> for that user so its only one record. Actually userid column doesnt
> exist on bankaccount table it exists only on the user table and it is
> joined with bankaccountid column, if i run this query separately i
> wouldnt able to run it .
>
>





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