Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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?

like image 235
Nathron Avatar asked Feb 02 '23 11:02

Nathron


1 Answers

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

like image 109
Nathron Avatar answered Feb 05 '23 15:02

Nathron