Will colease function in join condition invoke secondary index

Database

Will colease function in join condition invoke secondary index

Hi,

I have a query with join condition as below. I am planning to create secondary index as the fields used in join is not indexed. Will colease function in join condition invoke secondary index?.

INSERT INTO PROD_INT_SL_DIM_TARGET.N0001_AGREEMENT_GL_POSTING

( ........)

SELECT

.........

FROM PROD_INT_CORE_AUDIT.N0001_AGREEMENT_GL_POSTING AS glp

INNER JOIN PROD_INT_SL_DIM_TARGET.N0001_AGMNT_GL_PST_DIM AS gld

ON COALESCE(gld.Gl_Pst_Transaction_Typ_Cd,'N/A') = COALESCE(glp.Gl_Pst_Transaction_Typ_Cd,'N/A')

AND COALESCE(gld.Gl_Pst_Source_Cd,'N/A') = COALESCE(glp.Gl_Pst_Source_Cd,'N/A')

AND COALESCE(gld.Source_Cd,'N/A') = COALESCE(glp.Source_Cd,'N/A')

AND COALESCE(gld.Agmt_Gl_Pst_Typ_Cd,'N/A') = COALESCE(glp.Agmt_Gl_Pst_Typ_Cd,'N/A')

AND COALESCE(gld.Coa_Crncy_Id,-1) = COALESCE(glp.Coa_Crncy_Id,-1)

Regards

Sasikala

1 REPLY
Enthusiast

Re: Will colease function in join condition invoke secondary index

In my view no. One should avoid using functions in joins.