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