Creating a Bitmap Join Index in the List of Join Indexes:

You create a bitmap join index in the list of join indexes as follows:

1. Select Model > Join Indexes to open the List of Join Indexes.
2. Click the Add a Row tool and enter a bitmap join index name in the Name column.
3. Click the Properties tool to open the new bitmap join index property sheet.
4. Select a base table on the General tab, and then click the References tab.
5. 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.

6. 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.

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