Uploaded image for project: 'RH-SSO'
  1. RH-SSO
  2. RHSSO-1674

[RHSSO 7.0 performance] Table User_Entity is accessed using a Full Table Scan on Oracle an index is needed

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • Archive - 21'
    • RH-SSO-7.0.0.GA
    • Server
    • None

    • Production environment,
      I have pushed for RH-SSO 7.2 and it is working now on UAT,
      for production it's much harder to push for RH-SSO 7.2.

      Customer WOM, has been using RH-SSO for a long time.
      They have reported that an index is needed on the User_Entity Table since it is among the top offending queries on Oracle, as seen on the attachments.zip

      I've sent emails to sme (subject: RH-SSO 7.1 DB Tables way too big for production
      ), created a ticket (case 02259457)
      and now I'm filing this bug to get a proper answer , hopefully from Product Management.

              hmlnarik@redhat.com Hynek Mlnařík (Inactive)
              rh-ee-jgodoy Jerczey Godoy
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: