How to solve performance in Bulk import with index/non clustered index table.
Example:
Stored Procedure1: Inserting bulk records into table1
Stored Procedure2: retrieving data from table1 with certain condition
Stored Procedure3: retrieving all the data from table1
case 1: Sometime we may face locking issue while retrieving data.
Case 2: Applying isolation level Read Uncommitted we may get dirt read
How to resolve this issue. Every interview people are asking this question.
My answer is:
ans1. Disable the index before doing Bulk insert.But this will impact select query
ans2. Maintain only identity column with auto increment instead of primary key.
Please help. how to resolve that.