cancel
Showing results for 
Search instead for 
Did you mean: 

APD - Input Query partitioning

Former Member
0 Kudos
150

Hi all!

We currently designing an APD process with an input query that will deliver approx. 1M rows. On the second properties tab (Extended Setting) of the Input Query , an option is offered which should permit some kind of partitioning. Unfortunately this option is not documented. Do you have any experiences or a more detailed description of how it works ?

Any information is well appreciated.

Regards, Philipp

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member188975
Active Contributor
0 Kudos

Hi Philipp,

You can check note 751577:

You can use the partitioning available as of BW 3.20 to solve memory overflows. There, you can select a partitioning characteristic. For example, you can use it to create settings that determine that the system executes a query for each product group instead of a query covering all product groups. This reduces the consumption of memory because the system no longer

loads all the data into the main memory at the same time.

Hope this helps...