Query was taking one hour and thirty minutes without index on the column and to improve the speed of the query created index on the column love2(name changed) but this time it was taking more than two hours to execute.
we are doing BCP to insert the data in the table. any suggestion would be appreciated.
CREATE NONCLUSTERED INDEX [IDX_ID] ON [dbo].[love2] ( [VariableIDly] ASC ) INCLUDE ( [SerialKiller], [OrderChosenbutter], [Responsetowhat]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) GO