The Index Defaults tab displays
the index defaults associated with a DB Alias. The default index varies
depending on the database management system for which the DB Alias
is defined.
Identifier
Select
default options used to specify the identifier for new indexes. You
can create a new index based on the following:
- Table
- Identifier from the target table.
- Source
- Identifier from the source index.
- Current ID
- Current database
user ID from a destination.
- Explicit
- New identifier. If you select this option, you must
specify an identifier.
Allocation Percent
Allocation Percent, required
for Oracle and DB2® MVS™ only, allows
the adjustment of storage-related parameters on Create and Alter statements
for indexes. The allowable range is 0 to 999. The default value is
100.
- By default, the target SQL is created using the
values for the source objects in the Extract File.
- If you specify zero (0), the storage-related clause
in the SQL statement is omitted.
- Using any value other than zero results in a percentage
of the source value being used in the target clause.
Default Tablespace
Default Tablespace (segment, filegroup,
or Dbspace) is required for Oracle, Sybase ASE, Informix® and SQL Server. Select default
options used to specify the tablespace for new indexes. You can create
a new index based on the following:
- Table
- Same tablespace as the owning table.
- Source
- Same tablespace as the index in the Extract File
(if possible).
- Explicit
- Select the tablespace from the list of available
tablespaces for the database. Select <DEFAULT> to eliminate
any tablespace from the Create Index SQL statement and cause the index
to be created in the default tablespace.
Buffer Pool
The
buffer pool (e.g., BP1) that is to be used when creating an Index.
You can enter a specific value for the buffer pool or select a value
from the list. A Buffer Pool value is required for DB2 MVS only.
The list displays
any index buffer pools previously specified for this DB Alias, as
well as <DEFAULT> and <SOURCE>.
- <DEFAULT>
- Select to use the default buffer pool specified
by DB2 MVS. When creating an index, Optim does
not generate a BUFFERPOOL clause in the Create statement.
- <SOURCE>
- Select to use the same buffer pool as the index
of the source Archive or Extract File.