MySQL Forums
Forum List  »  Performance

Re: Using more than one Index
Posted by: James Day
Date: December 18, 2004 11:30AM

It's one per table alias, so if you used a self join you could use two or more indexes, one for each join/alias. Might involve rewriting quite a lot of queries, though.

Options: ReplyQuote


Subject
Views
Written By
Posted
4390
December 18, 2004 09:04AM
Re: Using more than one Index
2338
December 18, 2004 11:30AM
2344
December 18, 2004 12:36PM
2205
December 20, 2004 06:06AM


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.