CODEWITHSUNDEEP
sql-server
user368710
user368710

Reputation: 1

Update on #temp table is faster then the @ table variable

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

Upvotes: 0

Views: 278

Answers (1)

Chris Bednarski
Chris Bednarski

Reputation: 3424

Have a look here

There is no way to explicitely generate indexes on table variables and no statistics are kept for any indexes generated by contstraints.

Upvotes: 1

Related Questions