SET NOOJFLATTEN tells the query optimizer not to use the transformation that converts a NOT EXISTS/NOT IN subselect to an outer join with the containing query. The default is SET OJFLATTEN.