If I have a table, the table has two fields, the scene can be one of them will be used in the where the query, may also use both, joint only require two fields, how to design index is reasonable? I test 100000 volume of data explain and the profile no difference, but the problem is the interviewer asked, have who can help solve? Thank you very much