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

Hi, 

 

 

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.

 

Thanks,

Jaydeep

Outcomes