Re: MyISAM using 'wrong' index
The statistics are _usually_ kept up to date without any explicit OPTIMIZE (etc).
"normally I do select data from the joined table" -- since anything and everything can affect the optimization strategy, leaving out stuff means that we may not be addressing your actual problem.
Knowing the table sizes is sometimes important in analyzing a situation like yours.
InnoDB is recommended for many reasons.
http://mysql.rjweb.org/doc.php/myisam2innodb
Subject
Views
Written By
Posted
1923
June 08, 2015 04:14AM
1072
June 09, 2015 11:53PM
1626
June 30, 2015 03:22AM
1265
July 02, 2015 09:28PM
1129
July 03, 2015 03:16AM
Re: MyISAM using 'wrong' index
1168
July 04, 2015 11:10AM
1096
July 07, 2015 01:56AM
998
July 07, 2015 09:10AM
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.