Increased optimization time for queries with many join keys

Queries having 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. For more information, see the Performance and Tuning Guide.