0
I would like to know if you have any alternative means to improve the performance of a select without using the expression OR. Running only with an equal operator I get the result in 30min but including more conditions with use of OR there is an absurdly big time to get the result approximately more 10hs.
The fields involved in the merge are properly indexed?
– anonimo
I believe that yes más give an example of properly indexed?
– alex Tobias
Either they’re indexed or they’re not, "I believe so" is not an answer.
– anonimo
You tried to analyze the query execution plan to check the bottlenecks?
– anonimo
how do I analyze?
– alex Tobias
https://docs.oracle.com/cd/B28359_01/server.111/b28274/ex_plan.htm#PFGRF009
– anonimo
Try B.nf_vs_cod_pro in ( a.nf_vs_cod_pro01,a. nf_vs_cod_pro02...)
– Motta