MySQL Forums
Forum List  »  Performance

Re: Each morning some SQLs are very slow
Posted by: Peter Brawley
Date: May 08, 2017 06:30PM

> SQLs with "LIKE '%<sth>%'"

No indexing can help with LIKE '%...'; needs a table scan. Later in the day, performance may seem] better because MySQL can fetch the table scan from the cache.

Try to minimise use of LIKE '%...' on big tables.

Options: ReplyQuote

Written By
Re: Each morning some SQLs are very slow
May 08, 2017 06:30PM

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.