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