Mysql Improve Search Performance with wildcards (%%)

by

No, because MySQL will not be able to utilize the index when you have a leading wildcard. If you changed your LIKE to ‘f%’, then it would be able to use the index.

More Related Contents:

  1. How to do the Recursive SELECT query in MySQL?
  2. MySQL indexes – what are the best practices?
  3. Mysql::Error: Specified key was too long; max key length is 1000 bytes
  4. Subqueries with EXISTS vs IN – MySQL
  5. 60 million entries, select entries from a certain month. How to optimize database?
  6. Checking multiple columns for one value
  7. Mysql covering vs composite vs column index
  8. Whats the fastest way to lookup big tables for points within radius MySQL (latitude longitude)
  9. Higher cardinality column first in an index when involving a range?
  10. Does Order of Fields of Multi-Column Index in MySQL Matter
  11. Does a UNIQUE constraint automatically create an INDEX on the field(s)?
  12. MySQL optimizing INSERT speed being slowed down because of indices
  13. MySQL – why not index every field?
  14. Recreating a query using INNER JOIN? [duplicate]
  15. How to perform grouped ranking in MySQL
  16. MySQL Trigger after update only if row has changed
  17. MySQL “WITH” clause
  18. mysql select dynamic row values as column names, another column as value
  19. MySQL “Group By” and “Order By”
  20. MySQL Query to select data from last week?
  21. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  22. How do I use properly CASE..WHEN in MySQL
  23. How do I UPDATE a row in a table or INSERT it if it doesn’t exist?
  24. SQL unique varchar case sensitivity question
  25. How do I count columns of a table
  26. Why MySQL is giving error “Not allowed to return a result set from a function”?
  27. MySQL 5.6 – DENSE_RANK like functionality without Order By
  28. MySQL: Can I do a left join and pull only one row from the join table?
  29. MySQL OPTIMIZE all tables?
  30. Strip last two characters of a column in MySQL

Leave a Comment