Subject Re: [firebird-support] Re: Performance of the count Function.
Author Dennis Mulder
That's right Alexandre.
You could of course make (count)tables for each number of criteria and
create a combined primary key.

TABLE (
X,
Y1,
Y2,
Y2,
.
Yn,
COUNT,
PRIMARY KEY (Y1,Y2,Y3....Yn))

Dennis


Alexandre Benson Smith wrote:

>
> >
> >
> Yes, but I assume this could be done when one have a Defined number of
> choices, if the search arguments have "unlimted" combinations (sometimes
> one search criteria, sometimes 2, 3, etc). then this approach will not
> work :-(
>
> see you !
>