32 lines
1.2 KiB
Plaintext
32 lines
1.2 KiB
Plaintext
CREATE TABLE t_ndb(c1 INT NOT NULL PRIMARY KEY,
|
|
c2 INT NOT NULL,
|
|
c3 char(20),
|
|
KEY c3_idx(c3)) ENGINE=ndbcluster;
|
|
INSERT INTO t_ndb VALUES (1,1, '9412'), (2,2, '9413');
|
|
CREATE TABLE t_innodb(c1 INT NOT NULL PRIMARY KEY,
|
|
c2 INT NOT NULL,
|
|
c3 char(20),
|
|
KEY c3_idx(c3))ENGINE=INNODB;
|
|
INSERT INTO t_innodb VALUES (1, 1, 'a'), (2,2,'a'), (3,3,'a');
|
|
ANALYZE TABLE t_innodb;
|
|
Table Op Msg_type Msg_text
|
|
test.t_innodb analyze status OK
|
|
EXPLAIN SELECT COUNT(*) FROM t_ndb;
|
|
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
|
|
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL # # Select tables optimized away
|
|
Warnings:
|
|
Note 1003 /* select#1 */ select count(0) AS `COUNT(*)` from `test`.`t_ndb`
|
|
EXPLAIN SELECT COUNT(*) FROM t_ndb, t_innodb;
|
|
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
|
|
1 SIMPLE t_ndb p0,p1,p2,p3,p4,p5,p6,p7 ALL NULL NULL NULL NULL # # NULL
|
|
1 SIMPLE t_innodb NULL index NULL c3_idx 81 NULL # # Using index
|
|
Warnings:
|
|
Note 1003 /* select#1 */ select count(0) AS `COUNT(*)` from `test`.`t_ndb` join `test`.`t_innodb`
|
|
SELECT COUNT(*) FROM t_ndb;
|
|
COUNT(*)
|
|
2
|
|
SELECT COUNT(*) FROM t_ndb, t_innodb;
|
|
COUNT(*)
|
|
6
|
|
DROP TABLE t_ndb, t_innodb;
|