Datafusion 48 Clickbench Q6 and Q0 regression

[robert3005]

Describe the bug

When upgrading to Datafusion 48 our continous benchmarking infra detected a 25x regression in Q6 and 10x in Q0 of Clickbench. This query was previously answered all from stats which might not longer be the case if the slowdown is this significant

To Reproduce

No response

Expected behavior

No response

Additional context

No response

[AdamGS]

I think this behavior is expected, it's explicitly called out in #16080.

[AdamGS]

There's also an issue (#16158) to change the default config, I'll take it.

[robert3005]

One thing that's not clear to me is whether statistics will be fetched if you have a query that could be ansewered by statistics or will they not and you will run the full query

[AdamGS]

For ListingTable as it is now - the only thing taken into account is the config value.

[blaginin]

#16447 is merged so closing this