Re: Performance Questions 7.x

On Thu, 7 Mar 1996, Dave Kosenko wrote: > Using MATCHES with an anchored value is much > more efficient, as partial index searches can be done. The more unique the > part that you know, the faster the search (e.g. where col1 MATCHES "Jo*" is > good, where col1 MATCHES "Jone*" is better). If you are NOT using wildcards, > then you are better off using an "=". > > -- Is there a means to quantify or 'evaluate the risk' of using MATCHES for a non wild carded string? How much will I save if I use '=' instead of matches on a string supplied by a GUI? Thanks Steve Wallick Software Engineer Harris Publishing Systems Corp steve.wallick@harris.com