Chapter 15 DBMS-Specific Features

Creating a bitmap join index in the list of join indexes

If you need to create more bitmap join indexes than those automatically created by the rebuild process, you can use the list of join indexes.

To create a bitmap join index in the list of join indexes:

1. Select Model→Join Indexes.
   
   The List of Join Indexes is displayed.
2. Click a blank line in the list.
   
   or
   
   Click the Add a Row tool.
   
   An arrow is displayed at the beginning of the line.
3. Type a bitmap join index name in the Name column.
4. Click the Properties tool.
   
   A confirmation box is displayed asking you to commit the creation of the bitmap join index.
5. Click Yes.
   
   The bitmap join index property sheet opens to the General tab.
6. Select a base table in the corresponding box.
7. Click the References tab.
   
   The References tab is displayed. It contains the references of the bitmap join index. The list is empty when you create a new bitmap join index.
8. Click the Add References tool.
   
   A selection dialog box is displayed. It displays available references depending on the selected base table.
9. Select one or several references in the list.
10. Click OK.
    
    The selected reference is displayed in the References list.
    
11. Click the Columns tab.
    
    The Columns tab is displayed. It contains the columns of the bitmap join index. The list is empty when you create a new bitmap join index.
12. Click the Add Columns tool.
    
    A selection dialog box is displayed. It displays available columns depending on the selected references.
13. Select one or several columns in the list.
14. Click OK.
    
    The selected columns is displayed in the Columns list.
15. Click OK.
    
    The bitmap join index is created.

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