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?
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
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With