Query speed and key optimization

2003-07-10 Thread Wendell Dingus
I've been immersing myself in reading and trying to understand what I can about how keys and indexes work and the flow of a query. Here's an example of one that's not real efficient and I'm not sure if it can be made any more efficient or done some other way to go faster though. I'm guessing a

Re: Query speed and key optimization

2003-07-10 Thread Brent Baisley
It sounds like you are referring to full text indexing. Whenever you have to put a wild card at the start of a word, you should probably considering using full text indexing. It's easy to implement and the manual pages are fairly informative. On Thursday, July 10, 2003, at 02:41 PM, Wendell