Dnia 2004-02-02 15:46, Użytkownik Rigmor Ukuhe napisał:
> Hi,
>
> I have many indexes somehow overlaping like:
> ... btree ("STATUS", "VISIBLE", "NP_ID");
> ... btree ("STATUS", "VISIBLE");
>
> is perfomance gained by "more exact" index worth overhead with managing
> indexes.
The second (2 columns) index is useless - it's function is well done by
the first one (3 columns).
Regards,
Tomasz Myrta