Details
-
Bug
-
Status: Closed
-
Resolution: Fixed
-
Master
Description
Service Builder does not recognize when a it is creating a redundant index where the table contains a composite primary key or if it is a mapping table. For instance the following queries will show that the Primary index is being used instead of the index created specifically for the columns:
EXPLAIN SELECT * FROM master.Users_Orgs WHERE organizationId = 37094;
EXPLAIN SELECT * FROM UserGroupRole WHERE userId = 20139 AND groupId = 37062;
This cannot be tested manually.
Attachments
Issue Links
- is related to
-
LPS-79796 buildService command throws IllegalArgumentException
- Closed