One, the index type b-tree indexes Balanced binary tree, the default index type B-tree cluster indexes cluster's index type hash cluster indexes the hash index type Global and Local indexes index associated with patitioned table Reverse key indexes Oracle real application cluster use Bitmap Indexes bitmap index, Sosyang column values belong to a small The range function-based indexes based on the functional index Domain indexes
Second, the use of the principle of indexing as far as possible after inserting data to establish the index, because indexes will cause the insertion of data to slow down, especially when the unique index is indexed on the correct table and column to optimize the indexed column order improve performance limit the number of indexes per table Delete unwanted indexes The block setting of the specified index estimating the size of the index setting storage parameters To use parallel use of nologing to index the table space used by the specified index