30.4.3.37 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 statements_with_full_table_scans and x$statements_with_full_table_scans views have these columns:

• query

  The normalized statement string.

• db

  The default database for the statement, or NULL if there is none.

• exec_count

  The total number of times the statement has executed.

• total_latency

  The total wait time of timed statement events for the statement.

• no_index_used_count

  The total number of times no index was used to scan the table.

• no_good_index_used_count

  The total number of times no good index was used to scan the table.

• no_index_used_pct

  The percentage of the time no index was used to scan the table.

• rows_sent

  The total number of rows returned from the table.

• rows_examined

  The total number of rows read from the storage engine for the table.

• rows_sent_avg

  The average number of rows returned from the table.

• rows_examined_avg

  The average number of rows read from the storage engine for the table.

• first_seen

  The time at which the statement was first seen.

• last_seen

  The time at which the statement was most recently seen.

• digest

  The statement digest.