Understanding Oracle Indexes

B-tree Index Standard Oracle index is B-treeĀ based. A key is a column or expression on which you can build an index. Follow these guidelines for choosing keys to index: Consider indexing keys that are used frequently in WHERE clauses. Consider indexing keys that are used frequently to join tables in SQL statements. For more information…