Desc stock_transaction

Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
ID                                        NOT NULL NUMBER(10)
STOCK_BREAK_ID                                     NUMBER(10)
ISIN                                      NOT NULL VARCHAR2(12)
SECURITY_NUMBER                           NOT NULL VARCHAR2(12)
ACCOUNT_ID                                         VARCHAR2(5)
TRANSACTION_NUMBER                        NOT NULL VARCHAR2(16)
AMOUNT                                    NOT NULL NUMBER(30,4)
MARKET_VALUE                                       NUMBER(30,4)
DEPARTMENT_ID                                      VARCHAR2(5)
CATEGORY_ID                                        VARCHAR2(10)
STATUS                                    NOT NULL VARCHAR2(1)
LEDGER_STATEMENT                          NOT NULL VARCHAR2(3)
CUSTOMER_ID                               NOT NULL VARCHAR2(3)
VALUE_DATE                                NOT NULL DATE
STOCK_TYPE                                NOT NULL VARCHAR2(3)
SEC_LONGNAME                              NOT NULL VARCHAR2(100)
REMINDER                                           DATE
BOOKING_DATE                              NOT NULL DATE
TRANSACTION_OWNER_ID                               VARCHAR2(5)
FUNCTIONAL_OWNER_ID                                VARCHAR2(5)
BUSINESS_OWNER_ID                                  VARCHAR2(5)
ACCOUNT_NO                                         VARCHAR2(15)
LAST_UPDATE                                        DATE
EE2_USER_ID                                        VARCHAR2(10)


Data --> 80,000

Index --> Bitmap index on Department_ID

Select * from stock_transaction where DEPARTMENT_ID = 'VAUL' 

Index USEAGE -- NO

Select department_id from stock_transaction where DEPARTMENT_ID = 'VAUL' 
Index USEAGE -- Yes

Select department_id, count(*) from stock_transaction group by department_id
DEPAR   COUNT(*)
----- ----------
CAIN       20000
CAST       20000
CTRL       20000
SDM        19999
VAUL           1


INDEX_NAME   --> TEST_IDX 
INDEX_TYPE   --> BITMAP
TABLE_OWNER  --> XXBEAT                              
TABLE_NAME   --> STOCK_TRANSACTION