Hi Qlikers:
I need to reload a humongous table 20 million record and 102 fields.
I positively know that there is a parameter called Enable Parallel Load, that shares the task among processors.
Does anybody know how to set that for SAP? Where is set?
The next is an example for Oracle. 4 is the number of processors you want to use. This one reduces time to half.
Select /*+ PARALLEL(tabla1 , 4) PARALLEL(tabla2 , 4) */
Sum(tabla1.importe)
from tabla1, tabla2, tabla3
where tabla1.codigo = tabla2.codigo
and tabla2.codigo = tabla3.codigo
SQL does it automatically.
Thank you.
