Load data after selection

[avantime]

Hi,

I have a ~ 20 mil products database, split in multiple arborescent categories, each with it's own discount percentage.

If I load all the products, categories and percentages the classic way I end up with a 2 mld row table which is unusable due to it's size.

Is it possible to load the discounts after selecting the required categories? (in a server app, not desktop)

Thank you.