Re: MATCHES "*abc*" searches

On Mon, 28 Jul 1997, Ian Bangs wrote: > So a search for "*Jones*", and the like, are not uncommon. > > Illustra replied in sub-second times. IUS often takes over 45 seconds. > > Can anyone suggest a way to speed up this search? I cannot logically > think of a way that an index may be used in such a case. But why was > Illustra so much faster? Almost certainly. What sort of indexes are you using? The standard, a b-tree implementation, is almost useless in the situation you describe. IUS allows you many different options, and also offers access through the verity text datablade. I suggest that you start there with your quest for subsecond performance. -Richard ps: Yes, almost. There are always detached indexes and key-only scans, et cetera. Neyh.