Indexes can't be created explicitly on table variables, and no statistics are kept on table variables. Starting with SQL [!INCLUDEsssql14-md], new syntax was introduced which allows you to create ...

Learn the differences, benefits, and drawbacks of using temporary tables or table variables in T-SQL stored procedures, and how to optimize performance.