Ok - thanks for your input Sir..

Answers to your questions:

1) No, there is ONLY one clustered index (EventID) and it is an identity and will be incremented by value...

A view (dbo.EmisEventExtraction) populates dbo.EmisEvent table. So, dbo.EmisEventExtraction is a SQL View and not a table.

So the INSERT reads the above view to insert the records to dbo.EmisEvent. The view...

Thank you for the detailed explanation - I will really like to do the INSERT in batches and the table structure is as follows;

/****** Object: Table [dbo].[EmisEvent] ...