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

Popular posts from this blog

Unable to remove the www from url on https using .htaccess -