Re: Each morning some SQLs are very slow
> 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.
Subject
Views
Written By
Posted
1845
May 08, 2017 03:43PM
Re: Each morning some SQLs are very slow
875
May 08, 2017 06:30PM
1103
May 09, 2017 12:13AM
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.