Hence DROP the smaller index when it is an exact prefix of the larger. New comment: When you have both INDEX(a) and INDEX(a,b), the Optimizer sometimes picks the shorter (1-col) on even though the larger (2-col) would be better.In general, you should not have both only have the larger index. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |