Slow performance on export
(Doc ID 485423.1)
Last updated on FEBRUARY 01, 2023
Applies to:
Siebel Tools - Version 7.5.2.214 SIA [16066] and laterOracle Solaris on SPARC (64-bit)
Product Release: V7 (Enterprise)
Version: 7.5.2.214 [16066]
Database: Oracle 9.2.0.2
Application Server OS: Sun Solaris 2.8
Database Server OS: Sun Solaris 2.8
This document was previously published as Siebel SR 38-1376799537.
Goal
Users are exporting records returned from a PDQ they created. The PDQ SQL is to select all contacts that are marked as dirty. The dirty field is a calculated field (checkbox) which is determined based on a few conditions.
When the user wishes to export the records returned, it is taking a long time to run. After checking the SQL generated, there is no where-clause to determine if the record is dirty or not. The SQL seems to go through all contact records individually and on the front-end it determines if the record is dirty or not.
How can the export be made to run faster? How to utilise the calculated field 'Dirty' to work as a normal database field so that it appears in the where-clause of the SQL statement?
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |