Re: Query optimization and indexes

Tom Lane <tgl@sss.pgh.pa.us> writes:

> Before (if memory serves) 8.1, the planner would only consider leading
> index columns as potential indexscan qualifiers.  So given
>
>     where a = 5 and c = 4;
>
> only the a = 5 clause would be used with the index.  As of 8.1 it will
> consider using nonconsecutive index columns

Really? Is this the "skip scan" plan people were pining for? I missed when
that happened.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com