CODEWITHSUNDEEP
sql-serverdatabase-indexes
dublintech
dublintech

Reputation: 17785

Does SQL Server support hash indexes?

Are all the indexes in SQL Server B Tree?
Surely primary keys and foreign should be hash based indexes?

Upvotes: 4

Views: 5515

Answers (2)

Aaron Bertrand
Aaron Bertrand

Reputation: 280350

Not all indexes in SQL Server are B-tree indexes (SQL Server 2012 added columnstore indexes which are a bit different), but there is no such thing as a hash-based index there (yet).

Upvotes: 5

Giovanni B
Giovanni B

Reputation: 1032

Here's a pretty straight forward article explaining that all indices are b tree indices in SQL Server:

http://msdn.microsoft.com/en-us/library/ms177443(v=sql.105).aspx

I think if you want to get more into the nitty gritty of specific RDBMS' implementations, you could try posting to http://dba.stackexchange.com

Upvotes: 1

Related Questions