Thanks for the question, Md.
Asked: September 24, 2017 - 2:42 pm UTC
Last updated: October 19, 2017 - 1:58 am UTC
Version: Oracle 12c
Viewed 1000+ times
You Asked
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
and Connor said...
We're trying to help...we really are.
But the question guidelines (which you ticked to say that you had read) say:
"Give us a test case"
and you gave us nothing.
We then bounced this question back to with a video showing what a bad question is, and what a good question is....
and it still came back like this.
We could take *guesses* at what the problem...but that doesn't help anybody.
Is this answer out of date? If it is, please let us know via a Comment