Viewing 2 posts - 1 through 2 (of 2 total)
I will not be able to paste the entire query. But with the following query on AdventureWorks2012 database, I can demonstrate what is happening here.
Create VIEW View1
AS
SELECT BusinessEntityID, PersonType, FirstName,...
May 8, 2015 at 6:30 am
#1796527
I tried indexing the table as well. But that did not work. Moreover the slowness is there even if the temp table contains only one row.
May 8, 2015 at 2:46 am
#1796482