Inline indexes

SQL 2014 has many silent features one of them is inline indexes.
Whats inline indexes?
Inline indexes are which can be created while creating table.
We can specify index in Create Table statement itself.

Here is an example

CREATE TABLE test_table
     id   INT,
     data VARCHAR(max),
       INDEX idx1 (id)

1.We can create filtered index
2.We can not create columnstore index.

Good news is that both this issues resolved in SQL Server 2014.

No comments:

Post a Comment

Popular Posts