> Drop the index on Store_No, the selectivity is too poor for the

index

> to be useful (your GROUP BY query should execute somewhat faster
> without this index, probably equal to your DISTINCT query).

This is 1 example of a customers database, I have thousands of other
customers where this index is relavent.

Besides, my current database uses it in my example query and is
lightning fast compared to Firebird.