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

CREATE TABLE t1 (code INT);

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

CREATE INDEX i_t1_code 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