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.
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.
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/
