Dnia 2004-02-02 15:46, Użytkownik Rigmor Ukuhe napisał:

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

The second (2 columns) index is useless - it's function is well done by the first one (3 columns).

Tomasz Myrta

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly

Reply via email to