Ziele Untersuchung
mit Columbo Integrität von
Datenbanken Interaktion und
Portierbarkeit Ergonomie der
Schnittstellen

Angebot Produkte Projekt Beratung

Mittel Analytik Modellierung Sprachen Algebra Logik Hardware Denken Kreativität

Zusammenhänge Gesellschaft Wirtschaft Branche Firma

Benutzer


products/Sources/formale Sprachen/C/MariaDB/mysql-test/suite/perfschema/r/ (MariaDB Server Version 8.1-8.4^©) Datei vom 1.9.2026 mit Größe 10 kB

Quelle digest_view.result Sprache: Lisp

CREATE TABLE test.v1 (a int, b int);
INSERT INTO test.v1 VALUES (1, 100), (2, 200), (3, 300);
CREATE TABLE test.t1 (a int, b int);
INSERT INTO test.t1 VALUES (1, 100), (2, 200), (3, 300);
TRUNCATE TABLE performance_schema.events_statements_summary_by_digest;
EXPLAIN EXTENDED SELECT * from test.v1;
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE v1 ALL NULL NULL NULL NULL 3 100.00
Warnings:
Note 1003 select `test`.`v1`.`a` AS `a`,`test`.`v1`.`b` AS `b` from `test`.`v1`
EXPLAIN EXTENDED SELECT * from test.v1 where a = 1;
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE v1 ALL NULL NULL NULL NULL 3 100.00 Using where
Warnings:
Note 1003 select `test`.`v1`.`a` AS `a`,`test`.`v1`.`b` AS `b` from `test`.`v1` where `test`.`v1`.`a` = 1
EXPLAIN EXTENDED SELECT * from test.v1 where b > 100;
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE v1 ALL NULL NULL NULL NULL 3 100.00 Using where
Warnings:
Note 1003 select `test`.`v1`.`a` AS `a`,`test`.`v1`.`b` AS `b` from `test`.`v1` where `test`.`v1`.`b` > 100
EXPLAIN EXTENDED SELECT a, b from test.v1;
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE v1 ALL NULL NULL NULL NULL 3 100.00
Warnings:
Note 1003 select `test`.`v1`.`a` AS `a`,`test`.`v1`.`b` AS `b` from `test`.`v1`
EXPLAIN EXTENDED SELECT b, a from test.v1;
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE v1 ALL NULL NULL NULL NULL 3 100.00
Warnings:
Note 1003 select `test`.`v1`.`b` AS `b`,`test`.`v1`.`a` AS `a` from `test`.`v1`
SELECT * from test.v1;
a b
1 100
2 200
3 300
SELECT * from test.v1 where a = 1;
a b
1 100
SELECT * from test.v1 where b > 100;
a b
2 200
3 300
SELECT a, b from test.v1;
a b
1 100
2 200
3 300
SELECT b, a from test.v1;
b a
100 1
200 2
300 3
#
# DIGESTS SEEN ON TABLE
#
SELECT SCHEMA_NAME, DIGEST_TEXT, COUNT_STAR
FROM performance_schema.events_statements_summary_by_digest
ORDER BY DIGEST_TEXT;
SCHEMA_NAME DIGEST_TEXT COUNT_STAR
test EXPLAIN EXTENDED SELECT * FROM `test` . `v1`  1
test EXPLAIN EXTENDED SELECT * FROM `test` . `v1` WHERE `a` = ?  1
test EXPLAIN EXTENDED SELECT * FROM `test` . `v1` WHERE `b` > ?  1
test EXPLAIN EXTENDED SELECT `a` , `b` FROM `test` . `v1`  1
test EXPLAIN EXTENDED SELECT `b` , `a` FROM `test` . `v1`  1
test SELECT * FROM `test` . `v1`  1
test SELECT * FROM `test` . `v1` WHERE `a` = ?  1
test SELECT * FROM `test` . `v1` WHERE `b` > ?  1
test SELECT `a` , `b` FROM `test` . `v1`  1
test SELECT `b` , `a` FROM `test` . `v1`  1
test SHOW WARNINGS  5
test TRUNCATE TABLE `performance_schema` . `events_statements_summary_by_digest`  1
DROP TABLE test.v1;
CREATE VIEW test.v1 AS SELECT * FROM test.t1;
EXPLAIN EXTENDED SELECT * from test.v1;
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE t1 ALL NULL NULL NULL NULL 3 100.00
Warnings:
Note 1003 select `test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b` from `test`.`t1`
EXPLAIN EXTENDED SELECT * from test.v1 where a = 1;
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE t1 ALL NULL NULL NULL NULL 3 100.00 Using where
Warnings:
Note 1003 select `test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b` from `test`.`t1` where `test`.`t1`.`a` = 1
EXPLAIN EXTENDED SELECT * from test.v1 where b > 100;
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE t1 ALL NULL NULL NULL NULL 3 100.00 Using where
Warnings:
Note 1003 select `test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b` from `test`.`t1` where `test`.`t1`.`b` > 100
EXPLAIN EXTENDED SELECT a, b from test.v1;
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE t1 ALL NULL NULL NULL NULL 3 100.00
Warnings:
Note 1003 select `test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b` from `test`.`t1`
EXPLAIN EXTENDED SELECT b, a from test.v1;
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE t1 ALL NULL NULL NULL NULL 3 100.00
Warnings:
Note 1003 select `test`.`t1`.`b` AS `b`,`test`.`t1`.`a` AS `a` from `test`.`t1`
SELECT * from test.v1;
a b
1 100
2 200
3 300
SELECT * from test.v1 where a = 1;
a b
1 100
SELECT * from test.v1 where b > 100;
a b
2 200
3 300
SELECT a, b from test.v1;
a b
1 100
2 200
3 300
SELECT b, a from test.v1;
b a
100 1
200 2
300 3
#
# DIGESTS SEEN ON VIEW
#
SELECT SCHEMA_NAME, DIGEST_TEXT, COUNT_STAR
FROM performance_schema.events_statements_summary_by_digest
ORDER BY DIGEST_TEXT;
SCHEMA_NAME DIGEST_TEXT COUNT_STAR
test CREATE VIEW `test` . `v1` AS SELECT * FROM `test` . `t1`  1
test DROP TABLE `test` . `v1`  1
test EXPLAIN EXTENDED SELECT * FROM `test` . `v1`  2
test EXPLAIN EXTENDED SELECT * FROM `test` . `v1` WHERE `a` = ?  2
test EXPLAIN EXTENDED SELECT * FROM `test` . `v1` WHERE `b` > ?  2
test EXPLAIN EXTENDED SELECT `a` , `b` FROM `test` . `v1`  2
test EXPLAIN EXTENDED SELECT `b` , `a` FROM `test` . `v1`  2
test SELECT * FROM `test` . `v1`  2
test SELECT * FROM `test` . `v1` WHERE `a` = ?  2
test SELECT * FROM `test` . `v1` WHERE `b` > ?  2
test SELECT SCHEMA_NAME , `DIGEST_TEXT` , `COUNT_STAR` FROM `performance_schema` . `events_statements_summary_by_digest` ORDER BY `DIGEST_TEXT`  1
test SELECT `a` , `b` FROM `test` . `v1`  2
test SELECT `b` , `a` FROM `test` . `v1`  2
test SHOW WARNINGS  10
test TRUNCATE TABLE `performance_schema` . `events_statements_summary_by_digest`  1
DROP VIEW test.v1;
DROP TABLE test.t1;
CREATE TABLE test.v1 (a int, b int);
INSERT INTO test.v1 VALUES (1, 100), (2, 200), (3, 300);
CREATE TABLE test.t1 (a int, b int);
INSERT INTO test.t1 VALUES (1, 100), (2, 200), (3, 300);
TRUNCATE TABLE performance_schema.events_statements_summary_by_digest;
EXPLAIN SELECT * from test.v1;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE v1 ALL NULL NULL NULL NULL 3
EXPLAIN SELECT * from test.v1 where a = 1;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE v1 ALL NULL NULL NULL NULL 3 Using where
EXPLAIN SELECT * from test.v1 where b > 100;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE v1 ALL NULL NULL NULL NULL 3 Using where
EXPLAIN SELECT a, b from test.v1;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE v1 ALL NULL NULL NULL NULL 3
EXPLAIN SELECT b, a from test.v1;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE v1 ALL NULL NULL NULL NULL 3
SELECT * from test.v1;
a b
1 100
2 200
3 300
SELECT * from test.v1 where a = 1;
a b
1 100
SELECT * from test.v1 where b > 100;
a b
2 200
3 300
SELECT a, b from test.v1;
a b
1 100
2 200
3 300
SELECT b, a from test.v1;
b a
100 1
200 2
300 3
#
# DIGESTS SEEN ON TABLE
#
SELECT SCHEMA_NAME, DIGEST, DIGEST_TEXT, COUNT_STAR
FROM performance_schema.events_statements_summary_by_digest
ORDER BY DIGEST_TEXT;
SCHEMA_NAME DIGEST DIGEST_TEXT COUNT_STAR
test 8fd77e42aa215f1c392b12404e1f326f EXPLAIN SELECT * FROM `test` . `v1`  1
test d192506b4d7388fde34be0d045d4da28 EXPLAIN SELECT * FROM `test` . `v1` WHERE `a` = ?  1
test 70895eb62262c5cade510431bf74f623 EXPLAIN SELECT * FROM `test` . `v1` WHERE `b` > ?  1
test 812a7de7fda86d147fd519d2b761190f EXPLAIN SELECT `a` , `b` FROM `test` . `v1`  1
test 138f04079728d0beedc1f6e9775251b1 EXPLAIN SELECT `b` , `a` FROM `test` . `v1`  1
test 3dedb3adc3d28e9413564b8fa2e46092 SELECT * FROM `test` . `v1`  1
test 7ebd4b8fe4b1a9964824e393fd812f8a SELECT * FROM `test` . `v1` WHERE `a` = ?  1
test 9f5ab5996307a97866c9f9f8363c9dc4 SELECT * FROM `test` . `v1` WHERE `b` > ?  1
test faa8cac3db2ca32b1789b3c8e2da5d42 SELECT `a` , `b` FROM `test` . `v1`  1
test 8e4121e961fd6095fe63f0f1813c848b SELECT `b` , `a` FROM `test` . `v1`  1
test 5d31a5e3e18ae1ff1b65b95ceca583ee TRUNCATE TABLE `performance_schema` . `events_statements_summary_by_digest`  1
DROP TABLE test.v1;
CREATE VIEW test.v1 AS SELECT * FROM test.t1;
EXPLAIN SELECT * from test.v1;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 ALL NULL NULL NULL NULL 3
EXPLAIN SELECT * from test.v1 where a = 1;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 ALL NULL NULL NULL NULL 3 Using where
EXPLAIN SELECT * from test.v1 where b > 100;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 ALL NULL NULL NULL NULL 3 Using where
EXPLAIN SELECT a, b from test.v1;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 ALL NULL NULL NULL NULL 3
EXPLAIN SELECT b, a from test.v1;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 ALL NULL NULL NULL NULL 3
SELECT * from test.v1;
a b
1 100
2 200
3 300
SELECT * from test.v1 where a = 1;
a b
1 100
SELECT * from test.v1 where b > 100;
a b
2 200
3 300
SELECT a, b from test.v1;
a b
1 100
2 200
3 300
SELECT b, a from test.v1;
b a
100 1
200 2
300 3
#
# DIGESTS SEEN ON VIEW
#
SELECT SCHEMA_NAME, DIGEST, DIGEST_TEXT, COUNT_STAR
FROM performance_schema.events_statements_summary_by_digest
ORDER BY DIGEST_TEXT;
SCHEMA_NAME DIGEST DIGEST_TEXT COUNT_STAR
test 5262694dd83cb5c820b21d451cd74a78 CREATE VIEW `test` . `v1` AS SELECT * FROM `test` . `t1`  1
test 67a82e6286878f1cfa3ea515a3ce6a3a DROP TABLE `test` . `v1`  1
test 8fd77e42aa215f1c392b12404e1f326f EXPLAIN SELECT * FROM `test` . `v1`  2
test d192506b4d7388fde34be0d045d4da28 EXPLAIN SELECT * FROM `test` . `v1` WHERE `a` = ?  2
test 70895eb62262c5cade510431bf74f623 EXPLAIN SELECT * FROM `test` . `v1` WHERE `b` > ?  2
test 812a7de7fda86d147fd519d2b761190f EXPLAIN SELECT `a` , `b` FROM `test` . `v1`  2
test 138f04079728d0beedc1f6e9775251b1 EXPLAIN SELECT `b` , `a` FROM `test` . `v1`  2
test 3dedb3adc3d28e9413564b8fa2e46092 SELECT * FROM `test` . `v1`  2
test 7ebd4b8fe4b1a9964824e393fd812f8a SELECT * FROM `test` . `v1` WHERE `a` = ?  2
test 9f5ab5996307a97866c9f9f8363c9dc4 SELECT * FROM `test` . `v1` WHERE `b` > ?  2
test 64a00b61a5804ffa08fd7f5cfcc39c9a SELECT SCHEMA_NAME , `DIGEST` , `DIGEST_TEXT` , `COUNT_STAR` FROM `performance_schema` . `events_statements_summary_by_digest` ORDER BY `DIGEST_TEXT`  1
test faa8cac3db2ca32b1789b3c8e2da5d42 SELECT `a` , `b` FROM `test` . `v1`  2
test 8e4121e961fd6095fe63f0f1813c848b SELECT `b` , `a` FROM `test` . `v1`  2
test 5d31a5e3e18ae1ff1b65b95ceca583ee TRUNCATE TABLE `performance_schema` . `events_statements_summary_by_digest`  1
DROP VIEW test.v1;
DROP TABLE test.t1;

¤ Dauer der Verarbeitung: 0.9 Sekunden (vorverarbeitet am 2026-10-08) ¤

Wurzel

Suchen

PVS Prover

Isabelle Prover

NIST Cobol Testsuite

Cephes Mathematical Library

Vienna Development Method

Haftungshinweis

Die Informationen auf dieser Webseite wurden nach bestem Wissen sorgfältig zusammengestellt. Es wird jedoch weder Vollständigkeit, noch Richtigkeit, noch Qualität der bereit gestellten Informationen zugesichert.