IndexType Enumeration
Specifies the type of an index.
For an In-Memory OLTP code sample, see SQL Server Management Objects Support for In-Memory OLTP.
Assembly: Microsoft.SqlServer.SqlEnum (in Microsoft.SqlServer.SqlEnum.dll)
| Member name | Description | |
|---|---|---|
| ClusteredColumnStoreIndex | A clustered column store index. | |
| ClusteredIndex | A clustered index. | |
| NonClusteredColumnStoreIndex | A non-clustered column store index. | |
| NonClusteredHashIndex | A nonclustered hash index. For more information, see In-Memory OLTP (In-Memory Optimization). | |
| NonClusteredIndex | A non-clustered index. | |
| PrimaryXmlIndex | A primary XML index. | |
| SecondarySelectiveXmlIndex | A secondary selective XML index. | |
| SecondaryXmlIndex | A secondary XML index. | |
| SelectiveXmlIndex | A selective XML index. | |
| SpatialIndex | A spatial index. |
Show: