On 03 Dec 2012 10:53, Richard Schoen wrote:
I don't know if I stated it, but my assumption would be to only use
this technique for unique fields.

If I understand correctly... Care must still be taken, as I alluded. The assumption that the predicate will be used only on a UNIQUE protected column may be irrelevant, given any failure to ensure the situation that I had presented will never transpire. That is to suggest... The example I gave does have unique\distinct values. A LIKE [or equivalent LOCATE] predicate by itself, can not guarantee just one matching result amongst those distinct values; instead, either an equivalence [equal] predicate must be used, or some constraints on the data would be required to prevent those other predicates from ever yielding more than one matching row.

This thread ...

Return to Archive home page | Return to MIDRANGE.COM home page