The query processing steps taken when Component Integration Services is enabled are similar to the steps taken by Adaptive Server, except for the following:
If a client connection is made in passthrough mode, the Adaptive Server query processing is bypassed and the SQL text is forwarded to the remote server for execution.
When select, insert, delete, or update statements are submitted to the server for execution, additional steps may be taken by Component Integration Services to improve the query’s performance, if local proxy tables are referenced.
An overview of the query processing steps follows.
