Feedback
Did this article resolve your question/issue?

   

Article

Oracle Service Cloud error "Poor performing query"

« Go Back

Information

 
TitleOracle Service Cloud error "Poor performing query"
URL NameOracle-Service-Cloud-error-Poor-performing-query
Article Number000184699
EnvironmentProduct: Progress DataDirect for ODBC for Oracle Service Cloud Driver
Version: 7.1, 8.0
Product: Progress DataDirect for JDBC for Oracle Service Cloud Driver
Version: 5.1, 6.0
Product: DataDirect Cloud Oracle Service Cloud data source
Question/Problem Description
Error "Poor performing query - too many rows examined in statement" is returned from Oracle Service Cloud.  Are there configuration options that can help?
Steps to Reproduce
Clarifying Information
Error Message[DataDirect][ODBC Oracle Service Cloud driver][Oracle Service Cloud]Poor performing query - too many rows examined in statement [SELECT  * from RIGHTNOW.INCIDENT]
Defect/Enhancement Number
Cause
Queries sent to Oracle Service Cloud are resulting in large join operations on the Oracle Service Cloud backend, which are then terminated by the Oracle Service Cloud service.
Resolution
Set these options in the data source or connection string:

ConfigOptions=NamedIDBehavior=2
CreateDB=1                                            //Set this option the first time a connection is made, to force a new map to be created due to the ConfigOptions change above, then change back to 2..
WSFetchSize=10000                             //Use larger values if stmtCallLimit is hit, use smaller values if error "Poor performing query" is still encountered.
EnablePagingWithOrderByID=1       //This is the default value, so it probably does not need to be explicitly set.

Note: For DataDirect Cloud, NamedID Behavior is set on the Mapping tab under Set Map Options.
Workaround

 
Notes
Last Modified Date3/23/2016 6:01 PM
Attachment 
Files
Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.