creating index for memory optimized table without Primary key

Category: sql server dbdesign


Ceakn on Thu, 27 Aug 2015 10:42:27


I have a company database and I need to convert the tables to in-memory optimized tables.But some tables have no primary key.To create an index, I need to have a primary key . I cannot add primary key to the table and also the values of the table should be null for this database.In Microsoft site,it is written that  index cannot be created with null values.What can I do now?



Milan Das on Thu, 27 Aug 2015 11:23:52

Sorry Ceakn, You cannot create the index with a null column