Bitmap indexes may speed up many ad hoc queries, yes, but you should not forget to set up proper values for CREATE_BITMAP_AREA_SIZE and BITMAP_MERGE_AREA_SIZE.