Afternoon,
looking for some assistance in trouble shooting an situation that we currently have.
I have two identical, as far as I can tell, HANA system - DEV and TST.
Running 2.00.020.00.1500920972 (fa/hana2sp02) on SUSE Linux Enterprise Server 12.1, with Kernel Version SUSE Linux Enterprise Server 12.1.
Hana Studio is Version: 2.3.31
The issue we are experiencing is that content, calculation views, migrated via delivery unit produce difference execution plans - I have compared the result of the EXPLAIN STATEMENT against a SELECT from the final view.
The base tables used are identical and I have validated the imported content and am unable to see any differences.
Has anyone experienced anything similar before and if so, what was causing the difference. If not experienced before, any suggestions on how to analyse and determine the difference??
Any help, suggestions or solutions much appreciated as I have exhausted everything I can think of....
Dave