LucidDbAppLib COMPUTE STATISTICS FOR SCHEMA

From Eigenpedia

Contents 1 Syntax 2 Purpose 3 Parameters 4 Example 5 Source Code

Syntax

CALL APPLIB.COMPUTE_STATISTICS_FOR_SCHEMA( schemaname )

Purpose

Executes 'analyze table' with 'compute statistics for all columns' for all tables in a schema.

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://p4web.eigenbase.org/open/dev/luciddb/src/com/lucidera/luciddb/applib/analysis/ComputeStatisticsForSchemaUdp.java