CODEWITHSUNDEEP
sqlsql-serverindexingdata-structures
Chubaka
Chubaka

Reputation: 3135

SQL choose data structure during creating index?

May I know if there is any way to specify the data structure (B tree, hash table, R-tree etc.) of an index in a SQL (specifically SQL Server 2014)?

When I google it, I can only find the following syntax. Could any guru enlighten? Thank you!

CREATE INDEX name_index
ON table_name (Column_Name, Column_name2)

Upvotes: 1

Views: 131

Answers (1)

Liesel
Liesel

Reputation: 2979

The various types of index, use and the underlying structures are documented here

https://msdn.microsoft.com/en-US/library/ms175049(v=sql.120).aspx

Summary: Clustered and non-clustered on-disk indexes are B-Trees, Memory only indexes can be Hash based. Columnstore indexes differ again in their structure. (Not to mention Spatial, XML and Full Text indexes)

Upvotes: 4

Related Questions