Uploaded image for project: 'Grouper'
  1. Grouper
  2. GRP-1001

Registry needs to indexes to help with SQL export

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Minor
    • 2.2.0
    • 2.2.0
    • API
    • None

    Description

      Penn's DBAs said Oracle recommends these indexes. Applying them helped a SQL extract work (it worked, then for some reason it stopped, and this helped it)

      create index GROUPER_FIELDS_TYPE_IDX on GROUPER_FIELDS (TYPE)

      create index GROUPMEM_OWNID_FIELDID_IDX on GROUPER_MEMBERSHIPS (OWNER_ID,FIELD_ID)

      Attachments

        Activity

          People

            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: