This SQL query looks for large entities. The more identity records an entity has, the larger it becomes. Sometimes, the results of processing incoming identity data can cause the system to over-resolve identity records during entity and relationship resolution. Large entities can cause a marked slow down in system performance.
select entity_id count(dsrc_acct) as IDENTITY_CNT from DSRC_ACCT where sys_delete_dt is null group by entity_id count(dsrc_acct) > 100 order by count(dsrc_acct)desc;
In the Visualizer, use the Find by Entity ID screen to look up the Entity IDs returned by the Large Entities query results. Verify that the identities associated with this entity are properly associated. For properly constructed entities, the entity has many different data source accounts, while most of the data for associated names, addresses, and numbers of are very similar. If you have questions about whether the entity is properly constructed, contact your IBM Services or Support for further assistance.
ENTITY_ID | IDENTITY_CNT |
---|---|
3015 | 22 |
5241 | 41 |
7854 | 36 |