I was wondering how to perform a 'COMPUTE STATISTICS' with the brand new Oracle Connector stage. As I can see, it's available in the 'old' Oracle Enterprise Stage but not in the new one. Is that automatic? Or is it the 'Index maintenance option' that is doing the job?
I'm doing a bulk load with bulk load options :
Code: Select all
'Allow concurrent load sessions' = Yes,
'Index maintenance option' = Skip all,
'Disable logging' = Yes,
'Perform operations before bulk load' = Yes,
'Disable constraints' = Yes,
'Disable triggers' = Yes,
'Perform operations after bulk load' = Yes,
'Rebuild indexes' = Yes,
'Parallel clause' = PARALLEL
'Degree of parallelism' = 4
'Logging clause' = NOLOGGING
'Enable consatraints' = Yes
'Enable triggers' = Yes
eph