Oracle provides this nice data retrieving mechanism for low occurrence of DML operation tables. oracle bitmap index is proposed for low cardinality columns.