Re: select value between (start , end) optimisation

[James Day]

If alpha software is acceptable you might test to see if MySQL 5.0 helps. Not recommended for production use.

For earlier versions you need either one index which contains both fields or perhaps could try a self join. So, make an index with both start_field and end_field in it. In general, try to have a single index containing all major where clause parts in the same order as your intended order by.