Hi!

This SP has

an initial query to load data in temp. table with 5 tables joins. This query executed within 15 seconds.

Then have 7 update queries to update diff. diff. columns of this Temp. table from diff. diff. tables.

Each of these updates executed within 5-10 seconds.

Then we have the SIMPLE SELECT statement to return all the rows (207958) of this TEMP. table.

Temp. table don't have Indexes. That's why tried to add Identity column and Non-Clustered Index on it and

in execution plan of this SIMPLE SELECT statement SQL is doing TABLE SCAN.

Will attach the snap of Execution Plan soon.