btree index

thomasliju
thomasliju used Ask the Experts™
on
What occassion we use btree index.. in an oracle database..
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Database Administrator
Commented:
Here is an article on oracle.com describing the two kinds of indexes.

BTree (or Binary Tree) is the default and is likely used most often unless you have an index column with low cardinality of values (where Bitmap is more efficient).

http://www.oracle.com/technetwork/articles/sharma-indexes-093638.html

Author

Commented:
Yes btree index is the default

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial