Mysql index has been used, why still show Using filesort??????? How can get rid of the user to modify filesort???????

CodePudding user response:

Try to increase sort_buffer_size

CodePudding user response:

Can use the u1. Vid and u1. Id to establish a joint index

CodePudding user response:

The alter table user the add key idx_id_vid (id, vid);