SELECT * FROM `schema_tables_with_full_table_scans`
|
object_schema | object_name | rows_full_scanned | latency | |
---|---|---|---|---|
sakila | actor | 625 | 1.06 ms | |
sakila | city | 125 | 2.46 ms | |
sakila | country | 100 | 2.36 ms | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 81 | 1.24 ms | |
sakila | film | 78 | 1.24 ms | |
sakila | film_actor | 78 | 122.30 us | |
sakila | customer | 60 | 1.62 ms | |
sakila | address | 25 | 48.70 us | |
BI22110308 | Branch | 5 | 74.20 us | |
BI22110308 | Customer | 5 | 1.47 ms | |
sakila | language | 4 | 40.72 us | |
sakila | category | 4 | 48.48 us | |
world | Country | 2 | 315.93 us | |
sakila | inventory | 2 | 2.72 ms | |
world | CountryLanguage | 1 | 330.50 us | |
test19 | pilote | 1 | 16.85 us | |
test19 | voiture | 1 | 19.40 us | |
sakila | payment | 1 | 1.03 ms | |
sakila | film_category | 1 | 11.59 us | |
sku | Attore | 1 | 2.11 ms | |
sakila | store | 1 | 619.14 us | |
sakila | film_text | 1 | 282.44 us | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 1 | 22.77 us |
|