Dear Guys, I have two tables Query Performance Low while compare two lacks Loan ID with two tablesloan_id is nvarchar data type: 1. IFMR_BS_MCD_MFI_Template_PRM As A Table A Structure: Unique ID for Loan_ID Upload_File_ID int Client_ID nvarchar(200) Loan_ID nvarchar(200) 2. IFMR_BS_REPAY_SCHEDULE_PRM As B Table B Structure: Unique ID for Loan_ID Upload_File_ID int Client_ID nvarchar(200) Loan_ID nvarchar(200)The bellow query it will take the 3 to 5 minutes while compare above 20 thousand records
IFMR_BS_MCD_MFI_Template_PRM