Too many matching records found while querying Item EFF page

Summary: Please refer to attached document

Content (please ensure you mask any confidential information):

Too many matching records found. Specify additional criteria to limit the number of records.

We know that it is generic error, If there are too many records then application will show this message since retrieving all these values from the database tends to be performance burdening.

However, we want to understand where we can optimize our EFF attributes, value set or page to avoid this error message popping up

Version (include the version you are using, if applicable):

24D (11.13.24.10.0)

Code Snippet (add any code snippets that support your topic, if applicable):