Hi Rick, thanks for your reply! Hi Lily,
On Wed, Jan 19, 2011 at 10:23 PM, Lily Wei <[email protected]> wrote: > Hi Nirmal: > > I know there were a lot of talks about bitmap indexes from my other > prior company. > > I remember the conclusion is depending on the data type. For simple data > type (int, etc), it shall. > > For complex data type (blob, etc), it depending on whether i/o can be > decrease. Well, there might be other angle to > > look at the problem. > Thanks for the information. > > > Are you thinking of a project for optimizer? May I make a suggestion? > How about columnar search? It has been proven to be one of the best > methods so far. Infobright is also using it to build their index and they > are an open source database too. > I will look into columnar search Lily, thanks for the suggestion! > > > > > Hope this help, > > Lily > > ------------------------------ > *From:* Nirmal Fernando <[email protected]> > *To:* [email protected] > *Sent:* Wed, January 19, 2011 8:36:09 AM > *Subject:* Using Bitmap Indexes > > Hi All, > > Does Derby already use bitmap indexes? If not aren't using bitmap indexes > improve performance? > > Thanks! > > -- > Best Regards, > Nirmal > > C.S.Nirmal J. Fernando > Department of Computer Science & Engineering, > Faculty of Engineering, > University of Moratuwa, > Sri Lanka. > > Blog: http://nirmalfdo.blogspot.com/ > > > -- Best Regards, Nirmal C.S.Nirmal J. Fernando Department of Computer Science & Engineering, Faculty of Engineering, University of Moratuwa, Sri Lanka. Blog: http://nirmalfdo.blogspot.com/
