How to create BITMAP index in Oracle 11G
Example - Create bitmap index on the historyABC column of the PO table
SYNTEX -
CREATE BITMAP INDEX
emp_bitmap_idx
ON index_demo (gender);
SQL>CREATE BITMAP INDEX PO_HISTORYFLAG_IDX ON MXPRE.PO(historyABC);
SQL>execdbms_stats.gather_index_stats(OWNNAME=>'SYS',INDNAME=>'PO_HISTORYFLAG_IDX');
Example - Create bitmap index on the historyABC column of the PO table
SYNTEX -
CREATE BITMAP INDEX
emp_bitmap_idx
ON index_demo (gender);
SQL>CREATE BITMAP INDEX PO_HISTORYFLAG_IDX ON MXPRE.PO(historyABC);
SQL>execdbms_stats.gather_index_stats(OWNNAME=>'SYS',INDNAME=>'PO_HISTORYFLAG_IDX');
No comments:
Post a Comment