SQL/MX 2.x Database and Application Migration Guide (G06.23+, H06.04+, J06.03+)

Converting an SQL/MP Database to SQL/MX Tables
HP NonStop SQL/MX Database and Application Migration Guide—540435-005
11-26
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 an SQL/MP database into
an 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-20.
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 an SQL/MX table. Update statistics for every
table column involved in a query.
The larger the table, the longer UPDATE STATISTICS takes to run. The SAMPLE
clause can reduce the run time for large tables. Either run UPDATE STATISTICS as a
low-priority background process or during hours 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.