Update on #temp table is faster then the @ table variable.
Posted
by pansingh
on Stack Overflow
See other posts from Stack Overflow
or by pansingh
Published on 2010-06-16T21:51:14Z
Indexed on
2010/06/16
21:52 UTC
Read the original article
Hit count: 98
sql-server
In the similar query Update on #temp table is faster then the @ table variable.
But I m forced to use table variable as I am wokring with function. I feel index is not being picked up for table variable. I have unique clustered index.
Please help
© Stack Overflow or respective owner