Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 592
  • Last Modified:

btree index

What occassion we use btree index.. in an oracle database..
0
thomasliju
Asked:
thomasliju
1 Solution
 
Steve WalesSenior Database AdministratorCommented:
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
0
 
thomaslijuAuthor Commented:
Yes btree index is the default
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now