Analytics Hub Compare tab shows Performance degradation if comparison is done between real-time score and a collected scoreDescriptionWhen the real-time scores of an indicator are based on a large table, the Analytics Hub compare tab shows degraded performance, if the comparison is performed between a real-time score and a collected score. The performance degradation is due to the real-time query on the table defined in the indicator source.Steps to Reproduce Create around 100K incidentsCreate an indicator on the above tableOpen the Analytics Hub Notice the following: Compare tab is not visible on load, it takes longer to appear0 score values are seen at Deltas and after waiting about 45 seconds to 1 min the real values show Workaround Compare records was not designed as a tool to export records. Before navigating to the "Compare" tab in the Analytics Hub, select a particular date, for example "Yesterday", from the date picker on the Analytics Hub Overview tab instead of selecting the real-time (diamond icon). Then navigate to the Compare tab, the query completes within seconds because it goes to the Performance Analytics snapshot table instead of the large table defined in the indicator source. Related Problem: PRB1298485