SQL> explain plan for
  2  select *
  3  from test
  4  where n100=9
  5  and n3=0
  6  and n5=0;

Explained.

SQL> @xplan_outline

PLAN_TABLE_OUTPUT
----------------------------------------------------------------------------------------------------
Plan hash value: 2863980500

-----------------------------------------------------------------------------------------
| Id  | Operation                       | Name  | Rows  | Bytes | Cost (%CPU)| Time     |
-----------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                |       |    67 |   603 |    20   (0)| 00:00:01 |
|   1 |  BITMAP CONVERSION TO ROWIDS    |       |    67 |   603 |    20   (0)| 00:00:01 |
|   2 |   BITMAP AND                    |       |       |       |            |          |
|   3 |    BITMAP CONVERSION FROM ROWIDS|       |       |       |            |          |
|*  4 |     INDEX RANGE SCAN            | IX100 |       |       |     2   (0)| 00:00:01 |
|*  5 |    BITMAP INDEX SINGLE VALUE    | IX5   |       |       |            |          |
|*  6 |    BITMAP INDEX SINGLE VALUE    | IX3   |       |       |            |          |
-----------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   4 - access("N100"=9)
   5 - access("N5"=0)
   6 - access("N3"=0)

20 rows selected.


OUTLINES
---------------------------------------------------------------------------------------------------------
,q'[BITMAP_TREE(@"SEL$1" "TEST"@"SEL$1" AND(("TEST"."N100") ("TEST"."N5") ("TEST"."N3")))]'
,q'[OUTLINE_LEAF(@"SEL$1")]'
,q'[ALL_ROWS]'
,q'[DB_VERSION('12.1.0.2')]'
,q'[OPTIMIZER_FEATURES_ENABLE('12.1.0.2')]'
,q'[IGNORE_OPTIM_EMBEDDED_HINTS]'

SQL> @ hint  BITMAP_TREE

NAME                           SQL_FEATURE                         CLASS                          VERSION              INVERSE
------------------------------ ----------------------------------- ------------------------------ -------------------- ------------------------------
BITMAP_TREE                    QKSFM_BITMAP_TREE                   ACCESS                         10.2.0.1
BITMAP_AND                     QKSFM_BITMAP_TREE                   BITMAP_AND                     12.1.0.1