My Oracle Support Banner

Slow performance on export (Doc ID 485423.1)

Last updated on FEBRUARY 01, 2023

Applies to:

Siebel Tools - Version SIA [16066] and later
Oracle Solaris on SPARC (64-bit)
Product Release: V7 (Enterprise)
Version: [16066]
Database: Oracle
Application Server OS: Sun Solaris 2.8
Database Server OS: Sun Solaris 2.8

This document was previously published as Siebel SR 38-1376799537.



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?


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.