Together, the Integration service collation and the database collation determine which operations are sent to the database and which operations must be performed by the Integration service, as shown in Table 13-3. If the database would not perform an operation in the same way as the Integration service, the operation must be performed by the Integration service.
Table 13-3 Integration service collation Database collation All sort and comparison operations are sent to the database. GROUP BY and SELECT DISTINCT operations, DISTINCT aggregations, LIKE, POSITION, and string equality (=) comparisons are sent to the database.ORDER BY on strings, string comparisons other than equality, MAX, MIN, etc. must be performed by the Integration service. All operations must be performed by the Integration service. All sort and comparison operations are sent to the database. All operations must be performed by the Integration service.
|
|
Copyright Actuate Corporation 2012 |