SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ SUM(REASON) FROM (SELECT OBJ#, CASE WHEN BITAND(FLAGS, 16) != 16 THEN :B3 ELSE :B2 END REASON FROM SYS.TAB$ WHERE OBJ# = :B1 AND (BITAND(FLAGS, 16) != 16 OR SAMPLESIZE <> ROWCNT) UNION ALL SELECT OBJ#, CASE WHEN BITAND(FLAGS, 2) != 2 THEN :B3 ELSE :B2 END REASON FROM SYS.TABPART$ WHERE OBJ# = :B1 AND (BITAND(FLAGS, 2) != 2 OR SAMPLESIZE <> ROWCNT) UNION ALL SELECT OBJ#, CASE WHEN BITAND(FLAGS, 2) != 2 THEN :B3 ELSE :B2 END REASON FROM SYS.TABCOMPART$ T WHERE OBJ# = :B1 AND (BITAND(FLAGS, 2) != 2 OR SAMPLESIZE <> ROWCNT) UNION ALL SELECT OBJ#, CASE WHEN BITAND(FLAGS, 2) != 2 THEN :B3 ELSE :B2 END REASON FROM SYS.TABSUBPART$ WHERE OBJ# = :B1 AND (BITAND(FLAGS, 2) != 2) OR SAMPLESIZE <> ROWCNT)
