What should be ideal value of Filtered column in mysql explain clause?

13 Views Asked by Avyaan At 02 November 2022 at 03:49

rows shows the estimated number of rows examined and rows × filtered / 100 shows the number of rows that will be joined with previous tables.

in my case i have executed one simple select query on mysql 5.6 and 8.o and find that filtered column result is different.

 Explain SELECT * FROM  test_source ts WHERE ts.host_id=2 and ts.eventsource_id in( 1,19) limit 1;

Mysql 8.o output

mysql 5.6 Filtered column showing 100.

which should be the ideal value of filtered to compare the query cost?

There are 0 best solutions below