Description
To reproduce:
select * from `travel-sample` where type1 = "hotel" or type2 = "route";
Click on "advise" button;
Two recommended indexes:
CREATE INDEX adv_type1 ON `travel-sample`(`type1`)
CREATE INDEX adv_type2 ON `travel-sample`(`type2`)
Click on "CREATE AND BUILD INDEXES" button;
Either index1 or index2 will be created instead of both.
Attachments
Issue Links
- duplicates
-
MB-37735 Index Advisor: "Create & Build Indexes" only creates one index
- Closed