Slow performance when performing queries on EIP framework (Doc ID 854741.1)

Last updated on OCTOBER 19, 2016

Applies to:

Oracle Utilities Rate Management - Version: 4.5 to 4.53
LODESTAR EIP - Version: 4.5 to 4.53]
Oracle Utilities Meter Data Management - Version: 4.5 to 4.53]
Oracle Utilities Billing Component - Version: 4.5 to 4.53]
Oracle Utilities Quotations Management - Version: 4.5 to 4.53]
Information in this document applies to any platform.
***Checked for relevance on 25-May-2011***

Symptoms

The issue concerns the basic "select" SQL statement generated by the EIP framework. Apparently, the EIP framework is passing a value (that is not a number) into the "where" SQL clause condition; as a result, a function (TO_BINARY_DOUBLE) is applied to the input parameter of the "select" SQL clause. This is forcing Oracle to skip the use of the index that should be used as it is linked on the target table. This causes performance issues.

The question is: Why the input parameter passed from the EIP framework to the database has a type that is not a number?

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms