svanderclock wrote:

>
> someone already told me but i can not found it anymore:
> after i do a select, how to retrieve the indexed reads and non indexed reads statistics ? like ibexpert or ems firebird manager do
>

I think those are available from the MON$ pseudo-tables.

Thinking about what Arno said, you might get better results if
you used some rules about the queries you generate. For example
if the user specifies beds > 1, don't generate a criteria for
beds; instead, filter the results yourself.

For what it's worth, PostgreSQL does use histograms to monitor
the distribution of values in an index.
Good luck,

Ann