AppLib COMPUTE STATISTICS FOR SCHEMA

Syntax

CALL APPLIB.COMPUTE_STATISTICS_FOR_SCHEMA( schemaname )

Purpose

Executes 'analyze table' with 'compute statistics for all columns' for all tables in a schema. Causes LucidDB to create statistical information for optimizing performance of queries.

Parameters

• schemaname: name of schema containing tables to compute stats for [VARCHAR(255)]

Example

CALL APPLIB.COMPUTE_STATISTICS_FOR_SCHEMA( 'TESTSCHEMA' )

(doesn't return anything)

Source Code

http://p4webhost.eigenbase.org:8080/@md=d&cd=//open/dev/extensions/applib/src/org/eigenbase/applib/analysis/&cdf=//open/dev/extensions/applib/src/org/eigenbase/applib/analysis/ComputeStatisticsForSchemaUdp.java&c=iCU@//open/dev/extensions/applib/src/org/eigenbase/applib/analysis/ComputeStatisticsForSchemaUdp.java?ac=22