Optimizer Penalty for using LIKE + ORDER BY + LIMIT ?

: Optimizer Penalty for using LIKE + ORDER BY + LIMIT a) Using Full Text Search mysql SELECT a.dvd_id FROM dvd a, dvd_search s WHERE a.dvd_id = s.dvd_id and match (s.title) against ('breakfast' in boolean mode) ORDER BY a.title_sort, a.director LIMIT 0,50; 10 rows in set (0.00 sec) b) Using

Re: Optimizer Penalty for using LIKE + ORDER BY + LIMIT ?

needed. Please see below: Optimizer Penalty for using LIKE + ORDER BY + LIMIT a) Using Full Text Search mysql SELECT a.dvd_id FROM dvd a, dvd_search s WHERE a.dvd_id = s.dvd_id and match (s.title) against ('breakfast' in boolean mode) ORDER BY a.title_sort, a.director LIMIT