Queries with long chains of join keys may require additional time to optimize with Adaptive Server.
If the time required to optimize such a query is unacceptable, consider using an abstract query plan for the query.
The performance of these queries is improved with Adaptive Server version 15.0.