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






Limitations
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

Amazon Contextual Product Ads

Popular Posts