07.01.2016 19:44, Mark Rotteveel wrote: > That comment makes no sense. If there is no index it also needs to be > evaluated. It then uses NATURAL instead of an index access to find the > record(s) (or no records).
If the natural scan returns no rows, then WHERE conditions are not evaluated. For the indexed scan, conditions are evaluated either once (to compose the lookup key) or more (+ to check the condition) depending on whether the scan returns zero or more rows. Dmitry ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel