The 2020-11-08: in Mysql, three fields A, B, C joint index, query condition is B, A, C, would use the index? # # f greatly

CodePudding user response:

Joint index is one of the most left prefix principle, topic so that should not go index.

CodePudding user response:

Not according to the principle of the left