A bitmap join index has the following properties:
|
Property |
Description |
|---|---|
|
Name |
The name of the item which should be clear and meaningful, and should convey the item's purpose to non-technical users. |
|
Code |
The technical name of the item used for generating code or scripts, which may be abbreviated, and should not generally include spaces. |
|
Comment |
Additional information about the bitmap join index. |
|
Stereotype |
Sub-classification among bitmap join indexes. |
|
Owner |
Name of the user who created the bitmap join index. |
|
Base table |
Name of the table that stores the bitmap join index. |
The following tabs are also available:
Columns - Lists the columns used for the index. These columns proceed from the different dimension tables linked to the base table. When you create a bitmap join index manually, you have to select the columns to use. When you create a bitmap join index by rebuilding, the list of columns is initialized with all columns of the tables involved in the join except foreign keys.
References - Lists the references used for the index.
Physical Options - You can define physical options for bitmap join indexes generation. These options override the default physical options defined in the model. You can choose to generate these options by selecting the Physical Options check box in the Join Index groupbox in the Keys and Indexes tab of the Generation dialog box.