Query optimization - Select Into .. Alter Table ADD CONSTRAINT PRIMARY KEY ([ID] ASC)

SQLServerCentral » Latest topics

Query optimization - Select Into .. Alter Table ADD CONSTRAINT PRIMARY KEY ([ID] ASC)

I have an query in my project which is running for more than one hour.
I need help to Query optimization.
I am mentioning the steps followed since the query will have lot of columns and tables..Below are the steps followed with few columns an

more info...