Database Reference
In-Depth Information
Clicking Next you get to determine how you're going to create the primary key for the table. You get to supply it
with a name. Then you have to choose if you're going with a nonclustered hash or a nonclustered index. If you choose
the nonclustered hash, you will have to provide a bucket count. Figure 23-15 shows how I configured the key in much
the same way as I did it earlier using T-SQL.
Figure 23-15. Choosing the configuration of the primary key of the new in-memory table
Clicking Next will show you a summary of the choices you have made and enable a button at the bottom of the
screen to immediately migrate the table. It will migrate the table, renaming the old table however it was told to, and
it will migrate the data if you chose that option. The output of a successful migration looks like Figure 23-16 .
 
Search WWH ::




Custom Search