indexing - MySQL Table indexation -
i have table 11 fields. making select query data specific reason.
select `id` `a` b not null, c not null, d not null order e desc
i have made index on (b,c,d)
, (e)
mysql explain
shows possible_keys group index, key null, , in section there - using where; using filesort
full explain:
id|select_type|table|type|possible_keys key|key_len|ref|rows|extra 1|simple|m|all|get_movies|null|null|null|6694|using where; using filesort
Comments
Post a Comment