Error 1005025

"Query rejected as too complex. After join simplifications there were still %2 tables to be joined, which exceeds the current setting of Max_Join_Enumeration. %1"

Item Description

SQLCode

-1005025L

Constant

EMSG_JOINS_TOO_COMPLEX

SQLState

QTA25

ODBC 2 State

ERROR

ODBC 3 State

ERROR

Sybase Error Code

21089

Severity Code

14

Parameter 1

location of the exception

Parameter 2

the user name specified

Probable cause

The query will take too long to optimize, so it is being rejected


Created May 6, 2011. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com