Error using case when in where condition
In Oracle BI Publisher 11.1.1.6.10 :
How to optimise the case condition for the following data model query?
Both the query and the report work well but take about 40 seconds to give the result with a fact table of 100 lines.
The custromer has established that the slow performance is caused by the bind variable :P_Audioprotesista returning 400 lines because it was allowed to accept all values. He wants to filter the values to improve performance and thinks a case statement is the way to go. But this returns an error when the consumer selects more than one option in the prompt at runtime.
How to optimise the case condition for the following data model query?
Both the query and the report work well but take about 40 seconds to give the result with a fact table of 100 lines.
The custromer has established that the slow performance is caused by the bind variable :P_Audioprotesista returning 400 lines because it was allowed to accept all values. He wants to filter the values to improve performance and thinks a case statement is the way to go. But this returns an error when the consumer selects more than one option in the prompt at runtime.
0