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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

  From Date Subject
Next Message Mark Wimer 2011-05-31 16:54:55 Re: Create GEOM Column
Previous Message Michael Wood 2011-05-31 13:47:45 Re: indexes multicolumn