Bitmap indexes vs Regular indexes

2011-10-04 Thread Ron Tavares
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.

Re: Bitmap indexes vs Regular indexes

2011-10-04 Thread Guillaume Rheault
: 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

Re: Bitmap indexes vs Regular indexes

2011-10-04 Thread Rick Cook
@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

Re: Bitmap indexes vs Regular indexes

2011-10-04 Thread Axton
] 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

Re: Bitmap indexes vs Regular indexes

2011-10-04 Thread Garrison, Sean (Norcross)
, October 04, 2011 12:53 PM To: arslist@ARSLIST.ORG Subject: Re: Bitmap indexes vs Regular indexes ** Also keep in mind that certain form modifications will drop those indexes. If that happens you will need to recreate the indexes. It used to be that the alteration of the precision of a decimal

Re: Bitmap indexes vs Regular indexes

2011-10-04 Thread Axton
. ** ** Sean ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Axton *Sent:* Tuesday, October 04, 2011 12:53 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Bitmap indexes vs Regular indexes ** ** ** Also keep in mind that certain form