OPENIDM-11480 Remove outer-joined subquery from the relationship big query to support oracle 11
The above commit causes IDM to load the link expanded collection relationships one-by-one after calling the mega-query. The mega query should already be providing the data.
Create 2 users, one being a manager of the other. (or a user with 2 roles, or a role assigned to 100 users) The more items in the relationship collection will expose the reads taking place.
Make a query like
Note that the DB will be queried for the report users's data even though the data should be returned in the mega query.
Set logging level to see SQL - or put debug breakpoint on AugmentationChainFactory#145 - the logic should not reach that line as the referenced vertex fullobject/id should be there.