Chapter 15 DBMS-Specific Features

Creating a bitmap join index from the table property sheet

You can create a join index or a bitmap join index from the Join Index tab of the table property sheet. The bitmap join index is automatically based on the current table.

To create a bitmap join index from the table property sheet:

1. Open the property sheet of a table.
2. Click the Join Index tab to display the join index tab.
3. Click the Insert a Row or the Add a Row tool.
   
   A bitmap join index is automatically added to the list of table join indexes.
4. Click Apply and click the Properties tool to display the bitmap join index property sheet.
   
   You can check that the Base table box is initialized with the selected table.

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