Manually Creating Bitmap Join Indexes

You can manually create bitmap join indexes from the list of join indexes or via the base table property sheet.

1. Select  Model  Join Indexes  to open the List of Join Indexes, click the Add a Row tool, enter a bitmap join index name in the Name column, and then click the Properties tool to open the new bitmap join index property sheet.
2. Select a base table on the General tab.
   Note You can, alternately, create a bitmap join index from a table property sheet by clicking the Add a Row tool. In this case, the Base table field is set automatically.
3. Click the References tab, and then click the Add References tool to open a selection window, which lists the available references depending on the selected base table. Select one or more references in the list, and then click OK.

   The selected reference is displayed in the References list.

4. Click the Columns tab, and then click the Add Columns tool to open a selection window, which lists the available columns depending on the selected references. Select one or more columns in the list, and then click OK.

   The selected columns are displayed in the Columns list.

5. Click OK to complete the creation of the bitmap join index and return to the model.