Re: Query with multiples operators BETWEEN - Mailing list pgsql-general

From Neil Conway
Subject Re: Query with multiples operators BETWEEN
Date
Msg-id 20010222112320.A816@klamath.dyndns.org
Whole thread Raw
In response to Query with multiples operators BETWEEN  (Renaud Tthonnart <thonnart@amwdb.u-strasbg.fr>)
List pgsql-general
On Thu, Feb 22, 2001 at 05:10:51PM +0100, Renaud Tthonnart wrote:
> This qwery takes about 2 seconds :
[..]

Can you send us the output of EXPLAIN for each of these queries?
Also, how large are the tables you're working with? What
indexes have been created?

Cheers,

Neil

--
Neil Conway <neilconway@home.com>
Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc
Encrypted mail welcomed

Good composers borrow. Great composers steal.
        -- Igor Stravinsky

pgsql-general by date:

Previous
From: Renaud Tthonnart
Date:
Subject: Query with multiples operators BETWEEN
Next
From: Peter Eisentraut
Date:
Subject: Re: Errors in other languages