Sunday, October 12, 2014

1 SQL2014: T-SQL Create index inline with Create table statement

From SQL 2014, we can create the index inline in the create table statement . This was needed for in-memory optimized table because all the index for memory optimize table needs to be created in the table creation time. However, it can apply to the disk base table as well.

SQL2014

create table t5 ( 
    c1 int index ix_c1,
    c2 varchar(20)
)
 

or this

create table t6 ( 
    c1 int ,
    c2 varchar(20)
    index ix_c1 (c1)
  )
image

SQL2012

image

1 comments:

  1. Dear! It's my great honor to be on your blog,I benefit a lot from reading your blog.This data recovery cape town software also give me help .I want everybody to know it.

    ReplyDelete

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates