By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
version() |
---|
8.0.30 |
Records: 6 Duplicates: 0 Warnings: 0
Records: 0 Duplicates: 0 Warnings: 0
Id | Name | Other_Columns |
---|---|---|
3 | A | A_data_3 |
5 | B | B_data_2 |
6 | C | C_data_1 |
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | PRIMARY | t | null | ALL | PRIMARY,i1 | null | null | null | 6 | 100.00 | Using where; Rematerialize (<derived2>) |
1 | PRIMARY | <derived2> | null | ref | <auto_key0> | <auto_key0> | 12 | fiddle.t.Name,fiddle.t.Id | 2 | 100.00 | Using index |
2 | DEPENDENT DERIVED | t1 | null | ref | i1 | i1 | 7 | fiddle.t.Name | 2 | 100.00 | Using index |