Usually for a certain version of Oracle data and indexes may be stored in a limited number of ways, for example index-only tables, b-tree indexes, external tables, temporary tables… New types of indexes and tables require a version upgrade. This is a major distinction between Oracle and MySQL.
Continue reading…