Hi Ron, My thoughts are these bitmap indexes should be created at the database level, so that Remedy is not aware of them, because all Remedy created indexes are "standard" (i.e. b-tree indexes). After these indexes are created, the DBA can profile the overall performance again, to see if the expected benefits are there. Otherwise, the bitmap indexes should be dropped and the indexes created as b-tree through Remedy.
When you migrate the forms between environments, you need to remember to re-create these bitmap indexes at the database level. What BMC is saying that bitmap indexes are longer to write depends on the level of concurrency on the update of the bitmap index: it may or may not be an issue in your environment take a look at this article here: http://www.oracle.com/technetwork/articles/sharma-indexes-093638.html Guillaume ________________________________ From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Ron Tavares [ron.tava...@gmail.com] Sent: Tuesday, October 04, 2011 9:10 AM To: arslist@ARSLIST.ORG Subject: Bitmap indexes vs Regular indexes ** Good Morning List, I am a Remedy guy, not a DB guy,.. so I am looking for some help from the DBAs on the List. Recently, our DBA ran a performance analysis of our Remedy DB and came back with 9 fields that are recommended for indexing. 3 of those fields are recommended to have bitmap indexes. This cannot be created in Remedy. So we can either create these as standard indexes instead of bitmap, so that the Remedy system is aware of them, (this is what BMC is recommending). OR, we can have the DBA create them at the DB level as the recommended bitmap indexes, but then Remedy is not aware they exist. BMC is saying that bitmap indexes have a downfall in that they take a lot longer to write to. Our DBA is saying that we will not get the searching performance improvement we seek unless we use the bitmap indexes. Any thoughts from the pros? Thanks in advance, .ron _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
