Skip to Content
0
Former Member
Jul 20, 2010 at 03:17 PM

Infoset left outer join - performance limits

42 Views

A question regarding performance of left outer joins on two infoobjects:

We want to report on the installations without a contract. Since the contract infoobject has the installation ID, we want to put an infoset on the contract and installation infoobject, with the installation left outer joined to the contracts. After filtering on empty contract fields, we would have the installations of which the number is not in any contract.

We are dealing with about 2 million contracts and 2 million installations. We have not enough test data for a performance test. Therefore my question: if this scenario feasible?