29.11.2011 10:20, Mark Rotteveel wrote: > Wouldn't that give false positives? Or does the engine also compare the > actual (full) value after identifying a row in the index?
Yes, real values are always evaluated for rows selected by index. -- SY, SD. ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel