Uploaded image for project: 'Sentry'
  1. Sentry
  2. SENTRY-2210

AUTHZ_PATH should have index on the foreign key AUTHZ_OBJ_ID

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.1.0
    • Fix Version/s: None
    • Component/s: Sentry
    • Labels:
      None

      Description

      AUTHZ_PATH does not have index on the foreign key AUTHZ_OBJ_ID. When the number of entries become really large, a command like "select * from AUTHZ_PATH where AUTHZ_OBJ_ID = 8311512" becomes very slow because it results in table scan.

      To improve performance, we should add index for its foreign key in table AUTHZ_PATH.

      The sql script to do this in Oracle is "CREATE INDEX AUTHZ_PATH_FK_IDX on AUTHZ_PATH(AUTHZ_OBJ_ID);"

        Attachments

        1. SENTRY-2210.004.patch
          9 kB
          Na Li
        2. SENTRY-2210.003.patch
          65 kB
          Na Li
        3. SENTRY-2210.002.patch
          64 kB
          Na Li
        4. SENTRY-2210.001.patch
          64 kB
          Na Li

          Issue Links

            Activity

              People

              • Assignee:
                LinaAtAustin Na Li
                Reporter:
                LinaAtAustin Na Li
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: