Different types of database indexes?

database database-indexes
Nathron picture Nathron · Nov 30, 2011 · Viewed 29.8k times · Source

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?

Answer

Nathron picture Nathron · Nov 30, 2011

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

Related questions

How does database indexing work?

Given that indexing is so important as your data set increases in size, can someone explain how indexing works at a database-agnostic level? For information on queries to index a field, check out How do I index a database column.

Read More
A list of indices in MongoDB?

Is there a way to see a list of indices on a collection in mongodb in shell? i read through http://www.mongodb.org/display/DOCS/Indexes but i dont see anything

Read More
Neo4j: Step by Step to create an automatic index

I am creating a new Neo4j database. I have a type of node called User and I would like an index on the properties of user Identifier and EmailAddress. How does one go setting up an index when the …

Read More