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

Re: indexes multicolumn

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: Michael Wood <esiotrot(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: indexes multicolumn
Date: 2011-05-31 14:30:47
Message-ID: 20110531163047.22f37f9c@anubis.defcon1 (view raw or flat)
Thread:
Lists: pgsql-novice
On Tue, 31 May 2011 15:47:45 +0200, Michael Wood <esiotrot(at)gmail(dot)com> wrote:


...
> If you run:
> 
> explain analyze select name from test2 where major = const and minor = const;
> 
> and
> 
> explain analyze select name from test2 where minor = const and major = const;
> 
> you will see that the query planner is clever enough to see that they
> are the same.

I was almost sure about that:)
Thank Michael
JY
-- 
And miles to go before I sleep.
		-- Robert Frost

In response to

pgsql-novice by date

Next:From: Mark WimerDate: 2011-05-31 16:54:55
Subject: Re: Create GEOM Column
Previous:From: Michael WoodDate: 2011-05-31 13:47:45
Subject: Re: indexes multicolumn

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