MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Query not using full index
Posted by: KimSeong Loh
Date: August 02, 2005 12:34AM

From the EXPLAIN of the join, the datatable is the 3rd table and the index is used to optimise the join (ref), so the datetime index cannot be used anymore to optimise the between. Only 1 index can be applied for each table.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Query not using full index
2318
Perry Stupp
July 29, 2005 02:55PM
Re: Query not using full index
1445
Jay Pipes
July 30, 2005 08:16AM
Re: Query not using full index
1388
KimSeong Loh
August 02, 2005 12:34AM


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.