optimization via selection sets/indices
Robert Haussmann
haussma at nextdimension.net
Mon Oct 11 12:31:39 PDT 2004
[...]
> |
> | Automatic indices exist on fields 9, 2, and 16
> | (in this case, terms a, b, c, and d). In this particular
> | example, there are about 25 out of the 2M records that
> | fit the first criteria (9 eq "000575"). Shouldn't
> | rreport scan these records only? Is the selection set
> | too complex?
>
> What if you had a single automatic index on 9, 2 and 16 ?
>
Interesting possible solution. Just tried it, and there is
no change.
Bob
More information about the Filepro-list
mailing list