MAX_CARTESIAN_RESULT option

Function

Limits the number of rows resulting from a Cartesian join.

Allowed values

Any integer

Can be set temporary (for a connection), for a user, or for the PUBLIC group. Takes effect immediately.

Default

100000000

Scope

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.

Description

MAX_CARTESIAN_RESULT 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.