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
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
Viewing 2 posts - 1 through 2 (of 2 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy