Students have a large amount of data data article millions (or ten million), how to ensure the student id to check result (only) fast, at the same time guarantee the name check (results not only) faster?

CodePudding user response:

Student id as the primary key, and then to build an index on the name list