Answer the question
In order to leave comments, you need to log in
How to optimize a simple select * from table query?
Have a request
select ot.* from `my_table` as ot where ot.field01='11' and ((ot.field02='22' and ot.field03='33') or ot.field04='44' or ot.field05='55') order by ot.field06 desc limit 0, 20
Answer the question
In order to leave comments, you need to log in
describe/explain
indexes do not exist for this and are not composed in this way.
habrahabr.ru/post/70640
First of all, forget what happens * this is bad practice
Show indexes on the table and preferably create_table
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question