Tuning Considerations |
Virtual Machine |
 |
SQL Database
The basic operations of tuning an SQL database are the responsibility of the Database Administrator (DBA). However, various topics are covered here which have special relevance to PROIV.
Specify indices for column-sets referenced by PROIV as pseudo-keys, or column-sets referenced in ORDER BY clauses of Full Function mode statements.
It may be beneficial to use views of commonly used table-sets to reduce the complexity of SQL required by PROIV. Note however that views are often read-only (tables included in the view cannot be updated and are not portable to non-SQL systems).
Application Sorting
Do not use an ORDER BY clause unless the rows really do need sorting. If certain columns in a table are not required by PROIV, they may be omitted from the PROIV file definition (if inserts are to be performed, the columns must be either null-permissive or have default values). This slightly reduces the DBMS and PROIV work involved.
Topic ID: 720265