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