Hi
On 31 May 2011 15:18, Jean-Yves F. Barbier <12ukwn@gmail.com> wrote:
> Hi list,
>
> as the doc says:
>
> SELECT name FROM test2 WHERE major = constant AND minor = constant;
>
> then it might be appropriate to define an index on the columns major and minor
> together, e.g.:
>
> CREATE INDEX test2_mm_idx ON test2 (major, minor);
>
> I may ask a dumb question, but does the query planner also use such an
> index with the inversed query, e.g.:
>
> SELECT name FROM test2 WHERE minor = constant AND major = constant;
>
> or am I obliged to define an inversed index?
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.
--
Michael Wood <esiotrot@gmail.com>