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