Vector 6.0 | CREATE STATISTICS Example

SQL Language Guide > SQL Language Guide > SQL Statements > CREATE STATISTICS > CREATE STATISTICS Example

Was this helpful?

CREATE STATISTICS Example

1. Generate statistics for all columns in tables a and b and columns x, y, and z in table c:

CREATE STATISTICS FOR a, b, c(x, y, z);

2. Generate statistics for columns p and q of the global temporary table ttab. Subsequent queries that reference the temporary table will be compiled with those statistics:

CREATE STATISTICS FOR session.ttab(p, q);

Last modified date: 11/09/2022