Re: Poor Query

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

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 .
>
>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Pallav Kalva 2004-12-06 16:37:47 Re: Poor Query
Previous Message Tom Lane 2004-12-06 15:56:01 Re: Config Check