We are collecting the Accounts and User Account Mapping from ADC of type Oracle Database. In our database, we have Accounts and User Account Mappings in same table. How to optimize same, as per collector accounts will be collected running query on account table and then again it will query database for User Mappings on the same table. How to optimize collection in that case. We have larger dataset to be collected and this is adding up cost to run collection.
Query for Accounts and User Account Mappings
Select ID, UserID from AccountsTable
MyAccess Fields :: Database fields
Account ID/Name :: ID Column in Database
User ID :: UserID in Database
Please advise asap.