SAP Basis Tech Supports

Symptom

When the customer performs a search on an element type, the search takes lot of time to return the result.
Other terms

Performance,Search,Record,Case,Element type,Document,LOIO Search,Combined Search,Service provider space,SPS_ID
Reason and Prerequisites

The reason for the slow performance is, when a content model is made to host many service provider space (SPS) or Element types then the content model size can grow considerably. When a user performs a direct search on a element type without any search parameter in the search dialog then the records management performs Combined Search both on LOIO and PHIO tables. Since the size of the content model is very huge it takes time to read the records and filter the records based on RMS_ID, SPS_ID etc and build the final result.
Solution

The solution is perform a LOIO search instead of combined search when the user does not enter any attribute in the search dialog. The reason being the SPS_ID is a LOIO attribute and it is good to start the search from LOIO directly.
Also please implement the attached correction instruction to solve the problem.