Hi Tom,

I need to load my table with 55 millions of records using Merge statement
1. Those 55 millions records are being fetched from many different tables. For example T1,T2,T3 etc.

2. i have a date table from where i fetch business weeks based on date attributes like start date , insert date etc. There are 6 such dates attributes i am populating. Please note date table has 200 years of records already. I am using left outer with this date table six times for those 6 dates .

3. Also i am generating hash key based on few columns to detect SCD2.

For 8 million records i tried Merge statement. it is taking 845 secs.

Is it generating hash keys taking too much time ? or left outer six times ?

Please advise .

Thanks


Hi ,
1. I am using dbms_crypto.hash to generate hash for few columns of the table in order to detect changes. Alternatively if I use column1||column2||..||columnn to check i data has been checked.please advise if this is better option in compare to dbms_crypto.hash. Please note th table has 55 millions of records in the table for which I need to generate hash keys or concatenated string.

Regards
Afsar