db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nirmal Fernando <nirmal070...@gmail.com>
Subject Re: Using Bitmap Indexes
Date Fri, 21 Jan 2011 04:56:44 GMT
Hi Rick, thanks for your reply!

Hi Lily,

On Wed, Jan 19, 2011 at 10:23 PM, Lily Wei <lilywei@yahoo.com> 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 <nirmal070125@gmail.com>
> *To:* derby-dev@db.apache.org
> *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/

Mime
View raw message