Need HAccount index to find enabled users efficiently

Description

The modified queries in PR 485 are too expensive (probably full table scan) because there is no suitable index on HAccount.

We should consider reverting or reducing the rate limiter increases from https://github.com/zanata/zanata-platform/pull/490, since those limits and 429 errors helped to expose the problem with the index.

Environment

None

Status

Assignee

Alex Eng

Reporter

Sean Flanigan

Labels

None

Tested Version/s

None

Components

Sprint

None

Fix versions

Priority

High
Configure