Re: Poor Query

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