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 ...

SQL Server 2014 In-Memory OLTP introduces two new widely advertised kinds of database objects: memory-optimized tables for efficient data access, and natively compiled stored procedures for efficient ...