AnsweredAssumed Answered

How to optimize the User Account Mappings in Database Account Data Collector

Question asked by Jaydeep Mehta Employee on Aug 26, 2019
Latest reply on Aug 27, 2019 by Mostafa Helmy




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.


Demo Data


Accounts Table


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.