Hi Nirmal,
Derby does not use bitmap indexes. Some of the value of bitmap indexes
can be achieved by building regular btree indexes on generated columns,
where the generation clauses are boolean valued expressions built up out
of other columns in the row.
Regards,
-Rick
On 1/19/11 8:36 AM, Nirmal Fernando wrote:
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/