I am trying to run Report definition on Elastic Search rather Database. My Report Definition has 2 class joins with assign-workbasket class and one index join.
if we are running the Report against Database, we are seeing performance because of huge data in work basket table (over 1 M). so we are planning to use Elastic search for this to improve the performance. We i try to run RD with elastic search in tracer i can see that it is falling back to RDBMS saying it detected class join.
Can i please get the solution to use elastic search when we have class joins in Report and we have indexed Data and Rules, do we need indexing for Work classes also for Elastic Search?