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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
