SQL/MX Release 2.0 Best Practices

Managing and Monitoring 36
• Avoid the excessive use of CASE statements, data type casting, and function calls within a SQL
statement if these features can be performed within the logic of a program. Often compiled
application logic can perform these features more efficiently.
Managing and Monitoring
Catalog and Schema Placement and Maintenance
Maintain separate catalog and schema for test and production purposes. Drop catalog and schema
entries when they are no longer required. Keep production catalog and schema free of unnecessary
entries.
Keep catalog and schema fragmentation to a minimum by regularly performing online reloads. Do an
online reload after the initial creation of the database and after tables or partitions have been added
and dropped.
Statistics for catalog and schema cannot be maintained.
These measures will ensure the most efficient access to the catalog and schema tables.