When the parallel hint is specified in Compare command, the hint is put ahead of 'distinct' keyword.
select /*+ parallel(AC_DDTLACT_IT 4) full(AC_DDTLACT_IT) */ distinct
rowid,"CU_INGNO","ACO_TY","MNBR_CODE","ACO_DATE","ACO_CODE","BDD_BAL","TODAY_BAL",
"CRCT_OAMT_GSUM_AMT","LAST_CHNG_DTIM" from "DBOWN"."AC_DDTLACT_IT" PARTITION ("AC_DDTLACT_2015_02")
where ROWID IN (SELECT OOS_ROWID FROM SHAREPLEX_DATAEQUATOR_UPD_TEMP ) order by 2, 3, 4, 5, 6
As a result, the hint doesn't work as expected in Oracle.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center