Very Large data intensive operation on 19c.
Hello,
I would like to explain my requirement with a scenario.
- Table A is a source table with some 800 million (that's right) rows.
- Table B is another source table with some 600 million rows!
- I have to join table A and table B and based on this join conditions I have to regularly refresh another table C.
- In each run of #3, it is expected to pull in about 450 million rows in table C.
Currently this whole process takes upto 12 hours through traditional SQL/Old school route.
Are there any new features available in 12c, 18c, or 19c to optimize and speed up above mentioned operation?