前回の記事で少しだけ Range Index について触れましたが、CTP1 ではRange Index は未実装のようですね。ここに記載がありました。
Other Limitations
More on the not-supported list:
- DML triggers
- Data types
- Schema changes are not support in the same way as disk-based tables.
- There are no heaps in memory-optimized tables. (This is not a bad thing, just interesting. It makes sense though. A heap is just a bag of records in a particular spot. Records in memory have to have pointers for look-up.)
- Compression is not supported.
- Range indexes are expected to be available in CTP2.
Range Index は CTP2 で利用可能と予想される。予想ですか......少し不安が残ります。CTP2 でこの辺りは完全に対応してほしいと願っています。一番最初の部分に記載してある文章も少し気になりますが...
SQL Server 2014 will be a 1.0 version of this feature, and the development focus was on mainstream OLTP processing. Think light-weight transactional records processed with stored procedures. Many of the outlier OLTP features are not yet supported. Some of these gaps may be addressed by RTM, but some are not even planned until a later version.
ふぅ...メモリ最適化テーブルの実行プランが CTP2 で最適になるよう祈っています。下図のように....