I have two tables Query Performance Low while compare two lacks Loan ID with two tables
loan_id is nvarchar data type:
1.
Dear Guys, IFMR_BS_MCD_MFI_Template_PRM
I have two tables Query Performance Low while compare two lacks Loan ID with two tables
loan_id is nvarchar data type:
1.
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
How to improve the performence in that query.
Suraj SahooPosted Feb 6, 2015, 4:59 AM
I think you should implement INDEXING if you have not used it already. This helps is boosting the performance of the query.
http://www.codeproject.com/Articles/190263/Indexes-in-MS-SQL-Server
I hope this helps anyway.
Thanks