optimized away Skip_open_table, Open_frm_only, Open_trigger_only, Open_full_table Unique row not found Using filesort Using index Using index for group-by Using join buffer Using sort_union, Using union, Using intersect Using temporary Using where Using where