Case Study: Large Enterprise Professional Service Company achieves 10,000x Oracle performance improvement with Idera Precise

Professional Services Enterprise Improves Oracle Database Performance

Large Enterprise Professional Service Company, a U.S.-based provider of computer-assisted legal research, was struggling with slow performance in a business-critical Oracle Database application used by online users. The company worked with Idera’s Precise for Oracle Database to identify the bottleneck and analyze the heavy SQL statement driving excessive CPU usage.

Idera helped the company implement a new function-based index on `UPPER(USER_PERM_ID)` for the `PC_AFFILIATED_PERSON` table, allowing the SQL to use a better execution plan. As a result, average database time dropped from about 1.2 seconds to 0.12 milliseconds per execution, a nearly 10,000x improvement, saving roughly 10 hours of database time and helping the company avoid a planned hardware refresh.