Skip site navigation (1) Skip section navigation (2)

Re: Poor Query

From: Pierre-Frédéric Caillaud <lists(at)boutiquenumerique(dot)com>
To: "Pallav Kalva" <pkalva(at)deg(dot)cc>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Poor Query
Date: 2004-12-06 16:16:10
Message-ID: opsilgs8b4cq72hf@musicbox (view raw or flat)
Thread:
Lists: pgsql-performance

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




In response to

Responses

pgsql-performance by date

Next:From: Pallav KalvaDate: 2004-12-06 16:37:47
Subject: Re: Poor Query
Previous:From: Tom LaneDate: 2004-12-06 15:56:01
Subject: Re: Config Check

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group