https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-INDEX.html
Normal indexes. (By default, Oracle Database creates B-tree indexes.), used for high cardinality column.
Bitmap indexes, are small in size , used for low cardinality column., used in OLAP system where modification is rare as it locks the entire table.
refer https://tipsfororacle.blogspot.com/2016/09/oracle-indexes.html
Partitioned indexes, which consist of partitions containing an entry for each value that appears in the indexed column(s) of the table.
Function-based indexes, which are based on expressions. They enable you to construct queries that evaluate the value returned by an expression, which in turn may include built-in or user-defined functions.
Domain indexes, which are instances of an application-specific index of type indextype.
Refer https://tipsfororacle.blogspot.com/2017/02/index-usage-with-like-operator-and.html
No comments:
Post a Comment