MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0
These views display which tables are being accessed with full table scans. By default, rows are sorted by descending rows scanned.
The
schema_tables_with_full_table_scans
and
x$schema_tables_with_full_table_scans
views have these columns:
object_schema
The schema name.
object_name
The table name.
rows_full_scanned
The total number of rows scanned by full scans of the table.
latency
The total wait time of full scans of the table.