| B-Tree or Bitmap Indexes [message #128866] |
Thu, 21 July 2005 00:21  |
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  |
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 |
 |
Mahesh Rajendran
Messages: 10708
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
