![](https://secure.gravatar.com/avatar/06fb7e7f8217ef0e572a8334567b7559.jpg?s=120&d=mm&r=g)
Hello list I found out that EXPLAIN SELECT aggregate_func() FROM connect_table returns a "rows" value which is much greater than the rows in the table. For example: MariaDB [test]> SELECT COUNT(*) FROM t; +----------+ | COUNT(*) | +----------+ | 1000000 | +----------+ 1 row in set (0.49 sec) MariaDB [test]> EXPLAIN SELECT COUNT(*) FROM t; +------+-------------+-------+------+---------------+------+---------+------+---------+-------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +------+-------------+-------+------+---------------+------+---------+------+---------+-------+ | 1 | SIMPLE | t | ALL | NULL | NULL | NULL | NULL | 7783705 | | +------+-------------+-------+------+---------------+------+---------+------+---------+-------+ So, my question is: is there any difference in the output of EXPLAIN with CONNECT? Is CONNECT really reading 7.8 millions rows in a table with only 1 million rows? Regards Federico