My query getting 75% of cost in hash table join in execution plan
Query : select B.Tax_Value FROM PASS_INVOICE_FO RMAT_H A INNER JOIN PASS_INVOICE_TA X_D B
ON A.InvFor_Ref_Pk _Id =B.Tax_InvFor_F K_ID WHERE A.InvFor_Flag ='SOA' AND B.Tax_InvFor_Va lue ='Service Tax for Swachh Bharath cess'
and convert(date,ge tdate()) between convert(date,Ta x_FromDate) and convert(date,Ta x_ToDate)
Please provide the solution
Query : select B.Tax_Value FROM PASS_INVOICE_FO RMAT_H A INNER JOIN PASS_INVOICE_TA X_D B
ON A.InvFor_Ref_Pk _Id =B.Tax_InvFor_F K_ID WHERE A.InvFor_Flag ='SOA' AND B.Tax_InvFor_Va lue ='Service Tax for Swachh Bharath cess'
and convert(date,ge tdate()) between convert(date,Ta x_FromDate) and convert(date,Ta x_ToDate)
Please provide the solution