| From: | Pallav Kalva <pkalva(at)deg(dot)cc> |
|---|---|
| To: | Pierre-Frédéric Caillaud <lists(at)boutiquenumerique(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Poor Query |
| Date: | 2004-12-06 16:37:47 |
| Message-ID: | 41B48ADB.7000100@deg.cc |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Pierre-Frédéric Caillaud wrote:
>
>
> 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 ?
Just One, user can i have only one bankaccount.
>
>>>
>>> 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 | Josh Berkus | 2004-12-06 17:26:34 | Processor optimization compile options? |
| Previous Message | Pierre-Frédéric Caillaud | 2004-12-06 16:16:10 | Re: Poor Query |