Changing the Join Priority

In many cases, the position of a join within a SQL query can greatly affect query performance. To determine the positioning of a particular join within the SQL query generated by the physical view, you can specify a priority for the join.

Priority increases with value: 1=lowest, 10=highest. A join with priority 10 is placed before a join with priority 1.

To specify the priority of a join, follow these steps:

1. Click on the desired join line to select the join.

2. Right-click the join, and select 'Properties' from the context menu. This opens the 'Join Properties' dialog box.

 

3. In the 'Join Properties' dialog box, click the Options tab.

4. From the 'Order Priority' menu, select the desired priority for the join.

 

<< Defining the Join Type © 1996-2013 InetSoft Technology Corporation (v11.5) Changing the Join Operator >>