hi
I am just refereing the datastage pdf's, and had doubt avout using the variable APT_ORACLE_LOAD_OPTIONS to "OPTIONS (DIRECT=TRUE, PARALLEL=FALSE) options.
If we use this it will skip the Index creation, when the index will be created to improve the retrieval performance for Busienss Users. orelse do we need to do this database level?
Using APT_ORACLEAPT_ORACLE_LOAD_OPTIONS
Moderators: chulett, rschirm, roy
That particular option simply says to run a single-threaded direct path sqlldr session. It implies something about any indexes but doesn't "skip" anything. Have a chat with your DBA if you are unsure how sqlldr and those kind of options work.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers