Validating the Plan

Validating the plan allows you to check the integrity of the plan and SQL query execution.

The validation process checks each object in your plan (whether it is an ADOR, such as a Text ADOR, a Graphic ADOR or a Table ADOR; or a plan Object, such as a User View or Function), and compares the type of object to the type of expression that defines it.

If there are any discrepancies, an error message is displayed in the Output Pane. This message indicates the exact location of the error (including its line number and character number). Double-clicking the error message displays the relevant expression in the Expression Tabs Pane, with the cursor indicating the location of the error.

uPlan validates the plan using all data sources that are linked to your plan. If you have data sources that are not linked, you will be prompted to link your plan to data sources at this time (see Link the Plan to data).

To validate a plan:

1. Click the button on the toolbar.

   If any discrepancies are detected, a window opens to display the relevant errors and warnings.

2. Use the Tools menu options to navigate through the different errors and warning.