These are types of indexes:
trees
networks
spatial
distributed
hash
When choosing an indexing key:
the attributes in ORDER BY clause are candidates for the key
the attributes in FROM clause are candidates for the key
the attributes in HAVING clause are candidates for the key
the attributes in GROUP BY clause are candidates for the key
the attributes in WHERE clause are candidates for the key
The partitioning methods offered by Oracle are:
range partitions
hash partitions
list partitions
composite range-hash partitions
composite range-list partitions
In Oracle subpartitions can be:
range
list
index
cluster
When creating range partitions, there must be specified:
the partitioning method: range
the partitioning method: interval
the partition's column
the partition bounds
the partition values
Whatever the partition's type, the following elements must be specified:
the method
the intervals
the values
the partition columns
the number of partitions
When creating range-hash partitions, there must be specified:
the partitioning method: hash
the subpartitioning method: hash
the subpartitioning method: range
When creating has partitions, there must be specified:
the partition intervals
the columns of partitions
the partitioning method
