Can the UBP database table be cleaned since it contains excessive amounts of outdated data (e.g., for users/devices that don't exist anymore)?
Release : 9.1 SP2
Below is the query to cleanup the UBP data for the users who are deleted from the system.
DELETE FROM XUBPDATA where (USERNAME,ORGNAME) IN (SELECT USERID,ORGNAME from ARUDSUSER_ARCHIVE);
The DBA should be involved if the ARUDSUSER_ARCHIVE table has large data (approximately 1M) to add the necessary indexes.
Customer with only a few records (approximately 1k or 2k) does not need an index.