skip to main content
Performance tuning : Oracle Eloqua bulk operations : Efficient queries
 

Try DataDirect Cloud Now

Efficient queries

See your Eloqua documentation to understand the definition of minimal, partial, and complete column sets. Once you understand the columns included in each, the following guidelines will help to you choose the best performing query for your needs. When used in a query:
*A minimal column set provides the best performance. For example: SELECT name,description,createdBy FROM Account WHERE scheduledFor='May'
*A partical column set provides the next best performance. For example, SELECT name, description, createdBy, country FROM Account WHERE scheduledFor='May' is processed faster than: SELECT name, description, createdBy, country, c_website FROM Account WHERE scheduledFor='May', which contains columns from Complete Column Set.
*A complete column set is processed faster than a query that uses the bulk interface only when the required number of records is less than the actual number of records that the bulk query would return. For example, the following query would return all rows: SELECT name, country, c_website FROM Account WHERE scheduledFor='May'. While DataDirect Cloud would attempt to use bulk operations for such a query, suppose you were only interested in the first 500 of 10,000 records. In that case, the query SELECT TOP 500 name, country, c_website FROM Account WHERE scheduledFor='May' would probably be faster, even though it would not be fetched in a bulk operation.