Re: general design issue

paul c wrote:

> Bob Badour wrote:
> ...


>>>

>>> Here are my results, using statements that might be closer to what 


>>> you want:

>>>

>>> select distinct substr(key,5,1) from words where key GLOB 'inte*'   

>>> had an ET of 9

>>>

>>> returned the letters g,l,m,n,r,s

>>>

>>> whereas

>>>

>>> select distinct substr(key,5,1) from words where key like 'inte%'  

>>> had an ET of 314

>>>

>>> So, about a 30:1 difference between LIKE and GLOB.

Also, this statement had a higher ET of 37 as you might expect and returned 14 rows:

select distinct substr(key,2,1) from words where key GLOB 'i*' Received on Fri Apr 24 2009 - 18:15:18 CEST