Ohhh, things are not so simple. Firstly when you search data by the condition of the range you almost always get full table scan, the second important factor is the availability of a index by the field, order of the fields in the index, type and parameters of index, the third is the implementation of a query optimizer in a concrete database.