Home » RDBMS Server » Performance Tuning » About Bitmap Index
About Bitmap Index [message #268980] Thu, 20 September 2007 05:48 Go to next message
bagulia_pilla
Messages: 25
Registered: July 2006
Junior Member
I have one table which is the parition table. The table always updated and inserted. We have created Bitmap index for this table

It is true that ...

Bitmap indexes are not appropriate for tables that have lots of single row DML operations.. especially, concurrent single row DML operations..

Our DBA is saying why we need to drop bitmap Index.

Please help me

thanks
Re: About Bitmap Index [message #268985 is a reply to message #268980] Thu, 20 September 2007 06:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Please help me

Help you to what?
You have the answer: either bitmap index either DML but not both.

Regards
Michel
Re: About Bitmap Index [message #268987 is a reply to message #268980] Thu, 20 September 2007 06:23 Go to previous messageGo to next message
bagulia_pilla
Messages: 25
Registered: July 2006
Junior Member
Hi
That means,we need to drop Bitmap Index..

...since there is lot of row DML operations..
Re: About Bitmap Index [message #268988 is a reply to message #268980] Thu, 20 September 2007 06:26 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
read the document
http://www.akadia.com/services/ora_bitmapped_index.html

Another good documentation
http://www.oracle.com/technology/pub/articles/sharma_indexes.html

[Updated on: Thu, 20 September 2007 06:29]

Report message to a moderator

Re: About Bitmap Index [message #268999 is a reply to message #268987] Thu, 20 September 2007 07:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
That means,we need to drop Bitmap Index..

...since there is lot of row DML operations..

Yes.

Regards
Michel
Re: About Bitmap Index [message #269176 is a reply to message #268987] Thu, 20 September 2007 23:20 Go to previous message
bagulia_pilla
Messages: 25
Registered: July 2006
Junior Member
Thank You so much,, I got it from the example..
Laughing
Previous Topic: top query find through sqlplus ?
Next Topic: 0ra-1920
Goto Forum:
  


Current Time: Mon Dec 05 12:45:13 CST 2016

Total time taken to generate the page: 0.08004 seconds