Big performance difference between the query in BIP data model and the pure query
Summary:
The issue below has been observed
Performance of a custom BIP started to be extremly degraded post to the upgrade.
The BIP used to run in a second, but it started to run in more than 3 minutes after the update.
The weird thing is that Once I extract the pure query from the corresponding data model and run it with the hard-coded parameters, it run in a second as expected.
I was wondering why this big performance difference between the extracted pure query and the query in BIP.
Content (please ensure you mask any confidential information):
Big performance difference between the query in BIP data model and the pure query
Tagged:
0