How can I move an existing index on a normal table to a memory optimized file group?

Question

How can I move an existing index on a normal table to a memory optimized file group in sql server?

You don't. Memory optimized file groups are for memory optimized objects only, and you can't have a memory optimized index on a regular table -- it'd be impossible to keep in sync efficiently. (Well, not impossible, but unreasonably difficult to the point where it would defeat the purpose.) Nor can you convert a regular table to memory optimized on the fly; you have to create a new one. — Jeroen Mostert, Feb 01 '19 at 08:40

score 0 · Accepted Answer · answered May 06 '19 at 07:06

0

This is not possible,
Unless you move the table!

answered May 06 '19 at 07:06

1 Answers1