Different types of database indexes?
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:
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?
You should scour harder :-) - Wiki gives a good description
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.