Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!