Show TOC

Specifying Database-Specific ParametersLocate this document in the navigation structure

Use

Each database has its own specific behavior and optimization options that can be used to improve and optimize memory management, performance, and data access speed. To allow this improvement, Java Dictionary supports Database-Specific Parameters for particular databases.

The database-specific parameters can be set for tables, indexes, and primary keys during table or index design time, and are deployed on the database together with the corresponding object definition.

You specify the database-specific parameters in dedicated XML files within the table editor in the Dictionary perspective of the SAP NetWeaver Developer Studio.

The following rules apply to all of the supported databases:

  • You can set the database-specific parameters only for new tables.

  • The database-specific parameters settings are preserved if a table is dropped and re-created at once, or if it is converted.

  • You cannot set database-specific parameters for tables or indexes that already exist on the database.

  • You cannot set database-specific parameters for new indexes of tables that already exist on the database.

The following table shows the supported databases and the corresponding database-specific parameters:

Database

Database-Specific Parameters

Supported Objects

MS SQL Server

Clustered Index

Indexes, Primary Keys

IBM DB2 for Z/OS

Range Partitioning

Tables

IBM DB2 for Linux, UNIX, and Windows

Row Compression

Tables, Indexes, Primary Keys

Volatile

Multi-Dimensional Clustering

Database Partitioning

Clustered Index

Include Columns

Oracle

Bitmap Index

Indexes
Prerequisites

  • To specify table database-specific parameters, you must have created a table in Java Dictionary.

  • To specify index database-specific parameters, you must have created an index for a particular table in Java Dictionary.

  • To specify database-specific parameters for primary keys, you must have created a table in Java Dictionary, and you must have added a primary key column to that table.

  • You have opened the table for editing.

More information:

Creating Tables

Creating Indexes

Procedure

Specifying Table Database-Specific Parameters

  1. Choose the Technical Settings tab.

  2. If necessary, expand the Start of the navigation path Supported Databases Next navigation step Databases End of the navigation path nodes.

  3. In the context menu of the database you want to define specific parameters for, choose Start of the navigation path Table DB-Specific Parameters Next navigation step Add/Edit End of the navigation path.

    The table database-specific parameters configuration XML file opens.

  4. Choose the Design or the Source view of the XML file, then define the database-specific parameters for the table.

  5. Save your changes.

Specifying Index Database-Specific Parameters

  1. Choose the Indexes tab.

  2. If necessary, expand the Start of the navigation path <Index name> Next navigation step Properties Next navigation step Included Databases End of the navigation path nodes.

  3. In the context menu of the database you want to define specific parameters for, choose Start of the navigation path Index DB-Specific Parameters Next navigation step Add/Edit End of the navigation path.

    The index database-specific parameters configuration XML file opens.

  4. Choose the Design or the Source view of the XML file, then define the database-specific parameters for the index.

  5. Save your changes.

Specifying Database-Specific Parameters for Primary Keys

  1. Choose the Columns tab.

  2. Choose Define DB-Specific parameters for primary key columns.

  3. Select the database you want to define specific parameters for, then choose Finish .

    The primary key's database-specific parameters configuration XML file opens.

  4. Choose the Design or the Source view of the XML file, then define the database-specific parameters for the index.

  5. Save your changes.

More Information