Cube running against Oracle 19c shows longer execution time in Strategy 2021 GA compared with Strategy 2020U2.
2020
Query Engine Execution Start Time: 7/07/2021 2:25:31 PM
Query Engine Execution Finish Time: 7/07/2021 2:32:24 PM
Query Generation Time: 0:00:00.26
Total Elapsed Time In Query Engine*: 0:06:52.90
Sum of Query Execution Time: 0:00:59.31
Total Data Fetching and Processing Time: 0:01:23.71
Total Data Transfer from Datasource(s) Time: 0:03:34.73
Total Analytical Processing Time: 0:00:00.00
Total Other Processing Time: 0:04:47.54
2021
Query Engine Execution Start Time: 7/07/2021 1:28:23 PM
Query Engine Execution Finish Time: 7/07/2021 1:38:54 PM
Query Generation Time: 0:00:00.16
Total Elapsed Time In Query Engine*: 0:10:31.06
Sum of Query Execution Time: 0:00:59.65
Total Data Fetching and Processing Time: 0:01:46.60
Total Data Transfer from Datasource(s) Time: 0:04:02.71
Total Analytical Processing Time: 0:00:00.00
Total Other Processing Time: 0:07:58.72
NOTE: In MSTR 2021 the Data engine version 12 is being used. Upgrade to Strategy 2021 Update 2 still notice the performance difference.
CPU information shows this is not an apple-to-apple comparison. The impacted index sorting are basically Integer operation, and based on information online, Strategy 2021 Intelligence Server is 25+% slower than Strategy 2020 Intelligence Server.
m2021
Integer Math 29,209 MOps/Sec
https://www.cpubenchmark.net/cpu.php?cpu=Intel+Xeon+E5-2650+%40+2.00GHz&id=1218
m2020
Integer Math 39,409 MOps/Sec
https://www.cpubenchmark.net/cpu.php?cpu=Intel+Xeon+E5-2640+v4+%40+2.40GHz&id=2752
It is an expected behavior and there is no action needed in Strategy side.
