From: Pallav Kalva <pkalva@deg.cc>
To: Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Poor Query
Date: Mon, 06 Dec 2004 11:37:47 -0500
Message-ID: <41B48ADB.7000100@deg.cc> (raw)
In-Reply-To: <opsilgs8b4cq72hf@musicbox>
References: <41B47A97.1090708@deg.cc>
<opsilfifducq72hf@musicbox>
<41B48053.7090805@deg.cc>
<opsilgs8b4cq72hf@musicbox>
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 .
>>
>>
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pkalva@deg.cc, lists@boutiquenumerique.com
Subject: Re: Poor Query
In-Reply-To: <41B48ADB.7000100@deg.cc>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox