Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

Checking Statistics Information

Description

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

Syntax

csql> ;info stats <table_name>

  • table_name: Table name to check the statistics Information
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