tags:

views:

22

answers:

1
Q: 

how to perform operations on oracle9i b-tree index??

Hi,

i am using oracle9i. i have lot of questions to ask i want to create b-tree index on a table in the database.

  1. How can i do that??

  2. are these index same as that of written on wikipedia b-tree page??

  3. i want to perform b-tree operations(like insertion and deletion of entries) on these index b-trees.. can i do that??

please, help me!

A: 

The link below gives you a good idea.

link text

Chaitanya  2010-04-20 16:56:29
i read that article. it is good..but, still what i want to ask is,can i insert and delete entries from index b-tree in the way i insert and delete entries/keys in b-tree(implemented in some programming language like c/c++ or java)??
rohit  2010-04-20 17:18:19
index that stores a list of ROWIDS for each key, when an index is created it has an entry header, which stores number of columns and locking information, Key column length-value pairs, which define the size of a column in the key followed by the value for the column and ROWID's. The underlying operation is similar to what you mentioned but it's an abstraction you don't actually get to see insertion/deletion of keys. It happens in the background.
Chaitanya  2010-04-20 18:34:04
thanks a lot for quick reply!
rohit  2010-04-20 18:47:16

related questions

Maximum number of descendants in a B-tree
Are keys in B-tree nodes duplicated when the node is split?
Do btrees and b+trees only store data at the leafs?
What is a B-tree page
Do DB indexes take same amount of disc space as column data?
how B-tree indexing works in mysql
Best data structure for crossword puzzle search
Does anybody know how B-Tree got its name?
How are B Tree nodes typically represented?
C/C++: How to store data in a file in B tree
Advantages of BTree+ over BTree
Using code from a book without plagiarizing
size of B+ tree
Does anyone know where I might find a file based multi-way B-Tree Class for c#?
Looking for a disk-based B+ tree implementation in C++ or C
good ADT to implement BTREE
javascript binary search tree implementation
Which datastructure is appropriate for this situation?
Is there an API to draw a B-TREE?
saving Btrees to a disk file and read it
What's the difference between B-Tree and GiST index methods (in PostgreSQL)?
Larger than memory data structures and how they are typically handled
Techniques for Caching SQL Query Data
Binary Search or Btree index Update problem
What is a good open source B-tree implementation in C?