SQL/MP to SQL/MX Database and Application Migration Guide

Converting SQL/MP Tables to SQL/MX Tables
HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001
5-25
Using Third-Party Data Replication Tools
col=c2,6,10
col=c3,16,5
For more information about DataLoader/MX, see the DataLoader/MX Reference
Manual. For more information about import and the format file, see the SQL/MX
Reference Manual.
Using Third-Party Data Replication Tools
Several third-party data replication tools can copy data from a SQL/MP database into a
SQL/MX database. For more information about your options and how to use these
tools for migration, contact your service provider and see Assistance With Migration
on
page 1-15.
Updating Table Statistics
After you create new SQL/MX tables and populate them with data, update the table
statistics. The SQL/MX UPDATE STATISTICS command updates histogram statistics
for one or more groups of columns in a SQL/MX table. Update statistics for every table
column involved in a query.
If the table is large, it takes longer to run the UPDATE STATISTICS. The SAMPLE
clause can reduce the run time for large tables. Either run UPDATE STATISTICS as a
low-priority background process or when peak database performance is not required.
For more information about UPDATE STATISTICS, see the
SQL/MX Reference
Manual and the SQL/MX Query Guide.