18.104.22.168 The statements_with_full_table_scans and x$statements_with_full_table_scans Views
These views display normalized statements that have done full table scans. By default, rows are sorted by descending percentage of time a full scan was done and descending total latency.
The normalized statement string.
The default database for the statement, or
NULLif there is none.
The total number of times the statement has executed.
The total wait time of timed statement events for the statement.
The total number of times no index was used to scan the table.
The total number of times no good index was used to scan the table.
The percentage of the time no index was used to scan the table.
The total number of rows returned from the table.
The total number of rows read from the storage engine for the table.
The average number of rows returned from the table.
The average number of rows read from the storage engine for the table.
The time at which the statement was first seen.
The time at which the statement was most recently seen.
The statement digest.