Skip to content

Commit 4267e77

Browse files
authored
Update table-transact-sql.md
1 parent cfc9b9c commit 4267e77

1 file changed

Lines changed: 1 addition & 1 deletion

File tree

docs/t-sql/data-types/table-transact-sql.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -99,7 +99,7 @@ SELECT select_list INTO table_variable;
9999

100100
Queries that modify **table** variables do not generate parallel query execution plans. Performance can be affected when very large **table** variables, or **table** variables in complex queries, are modified. In these situations, consider using temporary tables instead. For more information, see [CREATE TABLE (Transact-SQL)](../../t-sql/statements/create-table-transact-sql.md). Queries that read **table** variables without modifying them can still be parallelized.
101101

102-
Indexes cannot be created explicitly on **table** variables, and no statistics are kept on **table** variables. Starting with [!INCLUDE[ssSQL14](../../includes/sssql14-md.md)], new syntax was introduced which allows you to create certain index types inline with the table definition. Using this new syntax, you can create indexes on **table** variables as part of the table definition. In some cases, performance may improve by using temporary tables instead, which provide full index support and statistics. For more information about temporary tables, see [CREATE TABLE (Transact-SQL)](../../t-sql/statements/create-table-transact-sql.md).
102+
Indexes cannot be created explicitly on **table** variables, and no statistics are kept on **table** variables. Starting with [!INCLUDE[ssSQL14](../../includes/sssql14-md.md)], new syntax was introduced which allows you to create certain index types inline with the table definition. Using this new syntax, you can create indexes on **table** variables as part of the table definition. In some cases, performance may improve by using temporary tables instead, which provide full index support and statistics. For more information about temporary tables and inline index creation, see [CREATE TABLE (Transact-SQL)](../../t-sql/statements/create-table-transact-sql.md).
103103

104104

105105
CHECK constraints, DEFAULT values and computed columns in the **table** type declaration cannot call user-defined functions.

0 commit comments

Comments
 (0)