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

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.