Limits the number of rows resulting from a cartesian join.
Any integer
Can be set temporary (for a connection), for a user, or for the PUBLIC group. Takes effect immediately.
DBA permissions are not required to set this option. Can be set temporary, for an individual connection, or for the PUBLIC group. Takes effect immediately.
10000000
This option limits the number of result rows from a query containing a cartesian join (usually the result of missing one or more join conditions when creating the query). If Sybase IQ cannot find a query plan for the cartesian join with an estimated result under this limit, it rejects the query and returns an error. Setting MAX_CARTESIAN_RESULT to 0 disables the check for the number of result rows of a cartesian join.
