In this blog post, you’ll learn more about the Sybase Error Query is too complex to optimize quickly. After join simplifications there were still %2 tables to be joined, which exceeds the setting for Max_Join_Enumeration. %1 and the reason for receiving this error
Sybase SQL Error Message
Query is too complex to optimize quickly. After join simplifications there were still %2 tables to be joined, which exceeds the setting for Max_Join_Enumeration. %1
Reason for this Error
The query will take too long to optimize, so it is being rejected