B-Tree or Bitmap Indexes [message #128866] |
Thu, 21 July 2005 00:21 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
milind_sri
Messages: 70 Registered: February 2005 Location: Pune
|
Member |
|
|
Hi Gurus,
I wanted to know which type of Index is better in what situations like in which scenario i should use B-Tree index and in which scenario i should use bitmap index.
I want this info in detail as my conecpts are not getting clear after reading the books and manual.
I want your suggestions in relevance to practical scenarios where you got better performance of B-Tree or Bitmap Indexes from the view of performance tuning of a query.
Pls. provide me with such practical scenarios where you people have undergone the performance situations.
Thanks in advance.
Milind.
|
|
|
|
|
Re: B-Tree or Bitmap Indexes [message #128996 is a reply to message #128866] |
Thu, 21 July 2005 08:15 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
smartin
Messages: 1803 Registered: March 2005 Location: Jacksonville, Florida
|
Senior Member |
|
|
In very very very general, if you are doing dml, you want btree, if not, you want bitmap.
Interesting site Girish, I'll have to check it out some more.
|
|
|
Re: B-Tree or Bitmap Indexes [message #129001 is a reply to message #128996] |
Thu, 21 July 2005 08:25 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/42800.jpg) |
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
>>Interesting site Girish, I'll have to check it out some more.
martin,
If you are referring to psoug url,
it is the library maintained by Daniel Morgan (C.D.O.S)~~.
The library is a very handy one.
|
|
|