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>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Poor Query
Date: 2004-12-06 15:48:05
Message-ID: opsilfifducq72hf@musicbox (view raw or flat)
Thread:
Lists: pgsql-performance
	How many rows do the following queries return :

select userID
              from bankaccount ba
              where ba.bankaccountID = u.bankaccountID
              and   ba.accountnumber = '12345678'

select userID
           from bankaccount ba
           where ba.bankaccountID = u.bankaccountID
           and ba.routingNumber = '12345678'

	Can you post EXPLAIN ANALYZE for these two queries ?
	Regards.

In response to

Responses

pgsql-performance by date

Next:From: Pallav KalvaDate: 2004-12-06 15:52:51
Subject: Re: Poor Query
Previous:From: Pallav KalvaDate: 2004-12-06 15:28:23
Subject: Poor Query

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