Chapter 3 Building Physical Diagrams
You access view index properties from the view property sheet:
| 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 | Descriptive label for the view index |
| Stereotype | Sub-classification used to extend the semantics of an object without changing its structure; it can be predefined or user-defined |
| Owner | Name of view index owner. You choose an owner from a list of users, the view index and view owners can be identical or different. A view index can only have one owner at a time. This is usually the view index creator |
| View | View for which the view index is defined |
| Type | Proprietary view index type (for those DBMS that support it). In Oracle, you can select the bitmap type. A bitmap index is used when you want to use a bitmap for each key value instead of a list of row Ids |
| Unique | Indicates whether the view index is a unique index |
| Cluster | Indicates whether the view index is a clustered index |
A view index also includes the following properties:
| Property | Description |
|---|---|
| Columns | Columns associated with view index |
| Options | Physical options for the view index. These are DBMS specific |
| Rules | Business rules attached to the view index |
| Copyright (C) 2005. Sybase Inc. All rights reserved. |
| |