You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-11-03 17:13:17 +03:00
34 lines
1.4 KiB
Plaintext
34 lines
1.4 KiB
Plaintext
DROP DATABASE IF EXISTS analyze_table_db;
|
|
CREATE DATABASE analyze_table_db;
|
|
USE analyze_table_db;
|
|
create table t1 (a int, b int, c int) engine=columnstore;
|
|
insert into t1 values (1, 2, 3), (2, 2, 2), (2, 3, 4);
|
|
analyze table t1 PERSISTENT FOR ALL;
|
|
Table Op Msg_type Msg_text
|
|
analyze_table_db.t1 analyze status Engine-independent statistics collected
|
|
analyze_table_db.t1 analyze status OK
|
|
create table t2 (a int, b double) engine=columnstore;
|
|
insert into t2 values (2, 3), (3, 4);
|
|
analyze table t2 PERSISTENT FOR ALL;
|
|
Table Op Msg_type Msg_text
|
|
analyze_table_db.t2 analyze status Engine-independent statistics collected
|
|
analyze_table_db.t2 analyze status OK
|
|
create table t3 (a varchar(25)) engine=columnstore;
|
|
insert into t3 values ("a"), ("b");
|
|
analyze table t3 PERSISTENT FOR ALL;
|
|
Table Op Msg_type Msg_text
|
|
analyze_table_db.t3 analyze status Engine-independent statistics collected
|
|
analyze_table_db.t3 analyze status OK
|
|
analyze table t1, t2, t3 PERSISTENT FOR ALL;
|
|
Table Op Msg_type Msg_text
|
|
analyze_table_db.t1 analyze status Engine-independent statistics collected
|
|
analyze_table_db.t1 analyze status OK
|
|
analyze_table_db.t2 analyze status Engine-independent statistics collected
|
|
analyze_table_db.t2 analyze status OK
|
|
analyze_table_db.t3 analyze status Engine-independent statistics collected
|
|
analyze_table_db.t3 analyze status OK
|
|
DROP TABLE t1;
|
|
DROP TABLE t2;
|
|
DROP TABLE t3;
|
|
DROP DATABASE analyze_table_db;
|