Question

9
Replies
2461
Views
Close popover
Srini B (SrinivasB4014)
JPMC

JPMC
US
SrinivasB4014 Member since 2016 1 post
JPMC
Posted: May 31, 2016
Last activity: August 17, 2016
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