Is there a way to use an index to avoid file set when OR is used in a MySQL query?

Question

I have the following query and the following 2 indexes, but I'm still getting the file port. Is there a way to optimize this further so that I avoid file management, or do I just need to live with it?

Inquiry:

SELECT * FROM table WHERE row1 > '0' OR row2 = '1' ORDER BY id DESC

Indices:

row1

row2, ID

EXPLAIN output:

Using sort_union (row1, row2_id); Use where; Using filesort

Answer 1

ORDER BY ROW2, ID or add index to ID.

Answer 2

Yes, you can. Just add an index like (id, row1, row2).

, , mySQL .

, sort_union() mySQL.

Answer 3

This is a bit late for an answer, but I want to say it using "or", possibly causing this problem. You can try combining with two different queries.