optimization via selection sets/indices

Kenneth Brody kenbrody at bestweb.net
Mon Oct 11 18:29:40 PDT 2004


Robert Haussmann wrote:
[... "index scan" not working with the following selection set ...]
> a and b and c and d and (e or f or g)
> a:9:eq:000575
> b:2:ge:07/01/2001
> c:2:le:12/31/2004
> d:16:eq:P
> e:3:eq:P
> f:3:eq:D
> g:3:eq:TR
[...]

Index scan is not available for selection sets containing an "OR".

-- 
+-------------------------+--------------------+-----------------------------+
| Kenneth J. Brody        | www.hvcomputer.com |                             |
| kenbrody/at\spamcop.net | www.fptech.com     | #include <std_disclaimer.h> |
+-------------------------+--------------------+-----------------------------+



More information about the Filepro-list mailing list