Re: better functionality in query ?

On Friday 06 April 2001 01:57, you wrote: > NOTE(!): LIKE '%foo%' DOES NOT SCALE. It looks like you are making a > phone book, which could get to be a lot of numbers. On the other hand > 'foo%' oddly scales to hundreds of thousands of records without any > problems (make sure it's key'd!). Well, if you think a bit about it it's not odd at all. For "%foo%" the DB has to examine the entire string until it finds an occurence of "foo" or until it reaches the end - and it can not use any (normal) index. for it. For "foo%" it just has to examine the first three chars - that's even faster than "WHERE phone = 'foobar-something'" and works very nicely with a perfectly normal index. -- Christian Reiniger LGDC Webmaster (http://sunsite.dk/lgdc/) I saw God --------- and she was black.