MySQL Forums
Forum List  »  General

Re: index multiple or one by one columns?
Posted by: Ameet Jayawant
Date: October 26, 2004 03:45AM

IMHO it depends on how you want to utilize the indexes. If most of your queries on this table are going to be composite, i.e. based on searching on all 3 cols at the same time then u are better off creating one index based on all 3 cols as in (2) in your example, else use seperate indexes.

Options: ReplyQuote


Subject
Written By
Posted
Re: index multiple or one by one columns?
October 26, 2004 03:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.