MySQL ‘filtered’ Explained: Query Efficiency

In MySQL, filtered represents the ratio of the data rows returned in a query to all data rows. It indicates the proportion of actual data rows returned in the query result set after filtering compared to the total data rows. This value is a decimal between 0 and 1, and can be used to measure the efficiency and accuracy of query conditions. The closer the value of filtered is to 1, the closer the query result is to all data rows; while the closer the value of filtered is to 0, the query result set only returns very few data rows.