View Single Post

   
  #5 (permalink)  
Old 02-28-2008, 10:58 AM
nk
 
Posts: n/a
Default Re: Indexes And Sorting

Using the (datelast, status) index would probably work, but
unfortunately I also have an index on ('status','somethingelse') in
the table, which I need for another query. Since this index's
cardinality is lower than the one of (datelast, status), MySQL chooses
the wrong index and I still have the same problem.

Any idea how I can force MySQL to use a certain index?

Reply With Quote