Tuning a Join When Using ODBC

A developer can tune a join when using ODBC.

When using ODBC, a developer tuning a join on T1 and T2 might go through the steps shown in the following figure.

Description of tune_join.gif follows
Description of the illustration tune_join.gif

During processing, the application may then go through the steps shown in the following figure.

Description of execution_steps.gif follows
Description of the illustration execution_steps.gif