How do we determine which column/s to be set when creating an INDEX? As I understand, using INDEX the query will be more faster then without using INDEX. How about using INDEX if query is a JOIN query, which involved 4 tables.
---------------------------(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