Checking Statistics Information

Description

You can check the statistics Information with the session command of the CSQL Interpreter.

Syntax

csql> ;info stats <table_name>

Example

The following example shows how to display the statistics Information of the t1 table in the CSQL Interpreter.

CREATE TABLE t1 (code INT);

INSERT INTO t1 VALUES(1),(2),(3),(4),(5);

CREATE INDEX ON t1(code);

UPDATE STATISTICS ON t1;

;info stats t1

CLASS STATISTICS

****************

 Class name: t1 Timestamp: Mon Mar 14 16:26:40 2011

 Total pages in class heap: 1

 Total objects: 5

 Number of attributes: 1

 Atrribute: code

    id: 0

    Type: DB_TYPE_INTEGER

    Mininum value: 1

    Maxinum value: 5

    B+tree statistics:

        BTID: { 0 , 1049 }

        Cardinality: 5 (5) , Total pages: 2 , Leaf pages: 1 , Height: 2