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
---------------------------(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
