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...
aspsenthil
Last Activity: Jun 6 '17, 04:55 AM
Joined: Jun 5 '17
Location:
-
aspsenthil started a topic Hash table inner join removal: My query getting 75% of cost in hash table join in exein SQL ServerHash table inner join removal: My query getting 75% of cost in hash table join in exe
No activity results to display