Is there a way to use the index to avoid a filesort when OR is used in MySQL query?

I have the following query and the following 2 indexes, but I am still getting a filesort. Is there a 开发者_StackOverflowway to optimize this further so that I avoid the filesort, or do I just need to live with it?

Query:

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

Indexes:

row1

row2,id

EXPLAIN output:

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

ORDER BY ROW2,ID or add an index on ID.

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

This index will work, because rows in it will be pre-sorted and mySQL will only need to select the satisfying lines.

Moreover, sort_union() index merging is not THAT good optimization for mySQL anyway.

It's a little bit late for answering but i want to say that, using "or" probably causing that problem. You can try using union with two different queries.