Adaptive Server provides other options for influencing optimizer choices:
Session-level options such as set forceplan to force join order or set parallel_degree to specify the maximum number of worker processes to use for the query
Options that can be included in the query text to influence the index choice, cache strategy, and parallel degree
There are some limitations to using set commands or adding hints to the query text:
Not all query plan steps can be influenced, for example, subquery attachment
Some query-generating tools do not support the in-query options or require all queries to be vendor-independent
