SQL Language Guide : 8. SQL Statements : CREATE STATISTICS : CREATE STATISTICS Example
 
Share this page                  
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);