OpenAccess SDK Service Attributes
:
Defining Service Attributes
:
ServiceSQLJoinInQueryOrder
ServiceSQLJoinInQueryOrder
Specifies the join order in a query that does not have an explicit HINT extension.
Valid values
0=Join processing uses the normal join processing algorithm.
1=Join processing uses the table ordering in the query (that is, from left to right).
2=Join processing uses the reverse table ordering in the query (that is, from right to left).
Default
0
Type
Static
IP Type
All
0=Join processing uses the normal join processing algorithm.
1=Join processing uses the table ordering in the query (that is, from left to right).
2=Join processing uses the reverse table ordering in the query (that is, from right to left).