SQL/MX Release 2.0 Best Practices

Performance Tuning 49
forced. You can use the DISPLAY USE OF command for programs, but that command does not list MXCI,
ODBC, or other dynamic queries that may be forced. Be careful if you use CONTROL QUERY SHAPE
because doing so could cause more problems in the long run for database maintenance and
performance. Using CONTROL QUERY SHAPE forces the same query even if the database changes. If the
database changes, a more efficient query may be available through normal use of the compiler without
using CONTROL QUERY SHAPE.