Re: Time difference for a query by changing one field?
Not much optimisation possible with a MyISAM table. More possibilities with InnoDB, esp. with 5.7 and 8.0.
The OR in the Where clause will slow things down. With a million rows and MyISAM, 2.3 sec would be considered good.
The Explain result might yield more info.
Subject
Written By
Posted
November 13, 2018 10:28AM
November 19, 2018 08:39AM
November 20, 2018 08:59AM
Re: Time difference for a query by changing one field?
November 20, 2018 10:09AM
November 30, 2018 08:00AM
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.