Re: indexes multicolumn - Mailing list pgsql-novice

From Jean-Yves F. Barbier
Subject Re: indexes multicolumn
Date
Msg-id 20110531163047.22f37f9c@anubis.defcon1
Whole thread Raw
In response to Re: indexes multicolumn  (Michael Wood <esiotrot@gmail.com>)
List pgsql-novice
On Tue, 31 May 2011 15:47:45 +0200, Michael Wood <esiotrot@gmail.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

pgsql-novice by date:

Previous
From: Michael Wood
Date:
Subject: Re: indexes multicolumn
Next
From: Mark Wimer
Date:
Subject: Re: Create GEOM Column