Right! Thanks Evgenij, I will change that immediately.
Thanks again guys.
On Friday, 30 September 2022 at 12:57:50 UTC+2 Evgenij Ryazanov wrote:
> Hello!
>
> You need to pass true as the last argument (approximate). It allows to
> return a fast approximation instead of exact number of rows in
Hello!
You need to pass true as the last argument (approximate). It allows to
return a fast approximation instead of exact number of rows in the index.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop
I read up on the method and now realize the call returns a number of
statistics (like CARDINALITY) that is based on the rows in the index. That
explains the slowness. The problem is that I only need to know which
indexes there are on each table and do not care about the statistics.
The tables