Hi all,
I am trying to create a table from select query which fetches around 5000 records.The query looks like
create table xx_test
AS (SELECT col1,col2,col3
from apps.ar_cash_receipts_all
where org_id=12345
and status<>'APP'
and receipt_method_id=345)
when i try to execute it is taking hours to complete and i tried using hint PARALLEL also but no improvement.Can any one please give there valuable suggestions.
Thanks