Question

9
Replies
2449
Views
SrinivasB4014 Member since 2016 1 post
JPMC
Posted: 4 years ago
Last activity: 4 years 1 month ago
Closed

Performance issue with filter “Contains” on report definition.

Hi,

We are not using elastic search due to hardware restrictions, planning to use “Contains” filter(Report Definition) to search a the case(s) from the Work- table, this could result in poor performance, we are looking for a better approach.

This question is to DBAs/SMEs, are there any best design practices to improve “Contains” query on Report definition?

Thank you

System Administration Data Integration Reporting
Moderation Team has archived post
Share this page LinkedIn