database 不同类型的数据库索引？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/8319425/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Different types of database indexes?
提问by Nathron
I am trying to compile a list of non-system-specific database indexes. I've looked at Oracle, DB2, MySQL, Postgres and Sybase, and almost every resource has a different list. So far I have seen:
我正在尝试编译非系统特定的数据库索引列表。我看过 Oracle、DB2、MySQL、Postgres 和 Sybase，几乎每个资源都有不同的列表。到目前为止，我已经看到：
clustered, multi-dimensional clustered, unclustered, unique,
non-unique, b-tree, hash, GiST, GIN, full-text, bitmap,
partitioned, function-based.
It seems that different systems have different names for the same types of indexes.
似乎不同的系统对相同类型的索引有不同的名称。
Are there standard index types across all systems?
是否有跨所有系统的标准索引类型？
回答by Nathron
If for whatever reason somebody else comes across this and is wondering the same thing, I ended up finding a good list at:
如果出于某种原因，其他人遇到了这个问题并且想知道同样的事情，我最终在以下位置找到了一个很好的列表：
http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems#Indexes
http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems#Indexes
回答by Adrian Cornish
You should scour harder :-) - Wiki gives a good description
你应该更努力地搜索:-) - 维基给出了很好的描述
回答by David Harkness
Many of the these concepts are orthogonal. A clustered index means that the rows are arranged in the table in the same order as they appear in the index. Independently, that index can be implemented using a B-tree, a B+ tree, a hash, spatially, etc. And then it may partition the table or not. One aspect may constrain but does not necessarily imply another.
许多这些概念是正交的。聚集索引意味着行在表中的排列顺序与它们在索引中出现的顺序相同。独立地，该索引可以使用 B 树、B+ 树、散列、空间等来实现。然后它可以对表进行分区或不分区。一个方面可能会限制但不一定意味着另一个方面。
回答by sundeep
http://msdn.microsoft.com/en-us/library/ms175049.aspx
http://msdn.microsoft.com/en-us/library/ms175049.aspx
these links might give more clear idea...
这些链接可能会给出更清晰的想法......
