DZone Database Zone
Data Transition With High Performance Between Hash Partitioned Tables
In this article, I’ll share the solution of a specific problem I had. I believe this will raise awareness for those experiencing the same problem.
We vehemently require data transitions between tables containing large-sized data while doing ETL development. But these functions may take a great deal of time. Often, we give the hint /*+parallel*/ to shorten this time, or we apply DIY parallelism techniques. Sometimes, performing these methods may take too much time — and sometimes, they may not even work. The technique I'm about to explain (when used appropriately) can greatly improve performance.
No comments:
Post a Comment