The document Markus points to seems to indicate that my simple OR query above would indeed be optimized to use the index. However I am still pretty convinced that we are not using the indexes in our own queries, given the speeds I see.
The document Markus points to seems to indicate that my simple OR query above would indeed be optimized to use the index. However I am still pretty convinced that we are not using the indexes in our own queries, given the speeds I see.