Hi,
I have a table as following schema -
CREATE TABLE [dbo].[hotel_info](
[hotel_code] [varchar](20) NOT NULL,
[images] [varchar](100) NULL
)
I have composite key on [hotel_code] and [images] columns .
Weekly, I get CSV file for inserting records into table. I have to insert only new records based on composite key from CSV to table.
Problem is CSV file has more than 2,00,000 records and there are only few new records weekly to insert.
So I am facing some performance degradation issue.
Could you please suggest few alternative approaches to tackle this scenario.
I have tried Subquery, NOT EXISTS, DISTINCT.
I am using MSSQL 2005 edition.