SQL Server 2016 is the biggest leap forward in Microsoft’s data platform history with faster transactions and queries, deeper insights on any device, advanced analytics, new security technology, and new hybrid cloud scenarios.
Yes. A HASH index is used on a Memory Optimized table. Clustered and NonClustered indexes are used for Disk based tables. There are Clustered and Non Clustered indexes for Coluymn Store indexes, but they are still used on disk based tables.
2018-04-27 19:51:18
1
Yes. A HASH index is used on a Memory Optimized table. Clustered and NonClustered indexes are used for Disk based tables. There are Clustered and Non Clustered indexes for Coluymn Store indexes, but they are still used on disk based tables.