Bitmap Index

Updated on 2023-04-03 GMT+08:00

View PDF

There is a configuration parameter that is introduced for this feature named BitmapIndexSupport which default value is comment, then the sample input and output are as follows:

Input – Bitmap index

   
      CREATE BITMAP INDEX 
emp_bitmap_idx
ON index_demo (gender);

Output

1	/CREATE BITMAP INDEX emp_bitmap_idx ON index_demo (gender);/

However, if the configuration parameter is set to BTREE, then the output is as follows:

Output

   
      CREATE
     /*bitmap*/
     INDEX emp_bitmap_idx
          ON index_demo
          USING btree (gender) ;

Parent topic: Oracle Syntax Migration

Previous topic: COMPRESS Phrase

Next topic: Custom Tablespace

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel