Chapter 15 DBMS-Specific Features

Adding a reference to a bitmap join index

You can add a reference to any bitmap join index. You do this, for example, when you create a new reference that you want to include in an existing bitmap join index.

To add a reference to a bitmap join index:

1. Select Model→Join Indexes to open the List of Join Indexes.
2. Select a bitmap join index in the list and then click the Properties tool to open its property sheet.
3. Click the References tab, and then click the Add References tool.
   
   A selection dialog box is displayed. It displays available references depending on the selected base table.
4. Select one or several references in the list.
5. Click OK to add the new reference to the References list:
   
6. Click OK to close the bitmap join index property sheet.

Copyright (C) 2007. Sybase Inc. All rights reserved.