Is there any way how to create an functioning index for this query?
SELECT id, title FROM recipes use index (topcat) where
(topcat='3' or topcat2='3' or topcat3='3') and approved='1' ORDER BY id DESC limit 0,10;
I created index "topcat" ( columns: topcat1+topcat2+topcat3+approved+id) but still ge "Using where; Using filesort". 🙁
