Chapter 15 DBMS-Specific Features
A bitmap join index has the following properties:
| Property | Description |
|---|---|
| Name | The name of the item which should be clear and meaningful, and should convey the item's purpose to non-technical users. |
| Code | The technical name of the item used for generating code or scripts, which may be abbreviated, and should not generally include spaces. |
| Comment | Additional information about the bitmap join index. |
| Stereotype | Sub-classification among bitmap join indexes. |
| Owner | Name of the user who created the bitmap join index. |
| Base table | Name of the table that stores the bitmap join index. |
The bitmap join index stores information about the columns used for the index. These columns are displayed in the Columns tab of the bitmap join index property sheet.
You can define physical options for bitmap join indexes generation. These options override the default physical options defined in the model. You can choose to generate these options by selecting the Physical Options check box in the Join Index groupbox in the Keys and Indexes tab of the Generation dialog box.
| Copyright (C) 2007. Sybase Inc. All rights reserved. |
| |