Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-92677

Redundant indexes are created where there are composite primary keys or it involves a table mapping

    Details

      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

            Activity

              People

              Assignee:
              summer.zhang Summer Zhang
              Reporter:
              jonathan.mccann Jonathan McCann
              Participants of an Issue:
              Recent user:
              Tomáš Polešovský
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                1 year, 26 weeks, 2 days ago

                  Packages

                  Version Package
                  7.1.10 DXP FP12
                  7.2.X
                  7.2.1 CE GA2
                  7.3.10 DXP GA1
                  Master