I have two tables which have one common column.
First table have 222874 rows and 43 columns. Second table have 4537 rows and 8 columns.
Normally I use sql to merge them, you can see below:
create table RAWDB2 as select a.*, b.linea, rskod, rsshd, rstag from lib.zH41006
a, line b where a.urkod=b.urkod;
But it takes too much time. How can I use hash table for this issue.