Subject | Re: [firebird-support] Re: Performance of the count Function. |
---|---|
Author | Dennis Mulder |
Post date | 2005-03-01T09:58:14Z |
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:
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 !
>