The IP can explicitly specify the order in which to process tables. The OpenAccess SDK SQL engine supports two ways for an IP to control how the OpenAccess SDK SQL engine determines the processing order for optimized JOIN processing:
• A SQL extension that allows use of the HINT keyword to specify the processing order.
• A configuration option on the server that is applied on every query that does not have an explicit HINT extension.
To enable this configuration option, add the ServiceSQLJoinInQueryOrder service attribute. You can set ServiceSQLJoinInQueryOrderto one of the following values:
• 0 - join processing uses the normal join processing algorithm (default)
