Geek Answers Handbook

Different types of database indexes?

I am trying to compile a list of non-system database indexes. I 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 on all systems?

+5
source share
4 answers

If for some reason someone else comes across this and asks the same question, I ended up finding a good list:

http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems#Indexes

+3
source

You have to make your way carefully :-) - The wiki gives a good description

http://en.wikipedia.org/wiki/Database_index

+2

. , , . , B-, B +, , .. . , .

+2

More articles:


All Articles