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.
The query processing steps are shown in Figure 2-2.An overview of these steps follows.
Figure 2-2: Query processing steps