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