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