Parallel Load

[christian77]

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.