Database column types used for AR System fields
In this topic:
- Microsoft SQL Server column types used for AR System fields
- Oracle column types used for AR System fields
The following sections list the column types used for AR System fields in each database type supported by BMC Remedy AR System.
Microsoft SQL Server column types used for AR System fields
The following table shows the Microsoft SQL Server column types used for each AR System field type whose values are stored in database tables.
Microsoft SQL Server column types used with AR System fields
Oracle column types used for AR System fields
Configuring process administrator capabilities shows the Oracle column types used for each AR System field type whose values are stored in database tables.
Oracle column types used with AR System field types
Large in-row CLOBs can degrade CPU performance, but small CLOBs can improve performance because the CLOB data can be fetched with the row from the database. AR System in-house application developers convert any character field designed to contain more than 255 bytes into a CLOB (database input length = 0). Typically, such fields are not expected to hold large amounts of data. Therefore, unless you expect to store unusually large amounts of data in CLOBs, set this option to TRUE before installing AR System applications so that all database tables for applications are created in-row.
- FALSE (default) --- CLOBs are created "out row."
Out-row CLOBs can cause the database to grow rapidly. Use out-row CLOBs only when your database storage is not limited and your CLOBs are expected to hold large amounts of data.
For more information about the storage and performance effects of using in-row versus out-row CLOBs, see Using-Oracle-CLOBs-with-BMC-Remedy-AR-System. The corresponding setting in the AR System server configuration file is Oracle-Clob-Storage-In-Row. |