SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Utilities

HP NonStop SQL/MX Reference Manual—523725-004

5-71

Examples of POPULATE INDEX

•

This example loads the specified index from the specified table:

POPULATE INDEX mycat.myschema.myindex ON

mycat.myschema.mytable;

•

This example loads the specified index from the specified table, which uses the

default catalog and schema:

POPULATE INDEX mycat.myschema.index2 ON table2;