MySQL Forums
Forum List  »  MyISAM

Advanced Search
New Topic

Re: slow performance / index not used
Posted by: Peter Brawley
Date: July 06, 2006 09:16AM

If FORCE INDEX in the subquery does not persuade the query engine to use the index, I'd move the subquery to a temp table query & join to that.

PB

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


Subject
Views
Written By
Posted
slow performance / index not used
3653
Alex Nguyen
July 05, 2006 12:21PM
Re: slow performance / index not used
1682
KimSeong Loh
July 05, 2006 05:42PM
Re: slow performance / index not used
1634
Peter Brawley
July 06, 2006 09:16AM
Performance
1833
Bob Hastie
July 14, 2006 12:07PM
Re: Performance
1629
Ingo Strüwing
July 19, 2006 01:27AM


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.