Re: Multiple Indexes

dennis(at)zserve(dot)com writes:

> If I were to define and index like this:
>
> 1) create index i on sometable ( name, somedata );
>
> and another one like this:
>
> 2) create index i2 on sometable ( name );
>
> Would that be better than defining only the first index?

While this kind of question is generally best answered through
experimentation and analysis of the actual query load, note that this
combination of indexes would be quite useless, because queries on "name"
could very well use the (name, somedata) index.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter