Re: [GENERAL] efficiency of wildcards at both ends

2012-06-20 Thread Sam Z J
thank you all for the useful information =D On Wed, Jun 20, 2012 at 1:39 PM, Alan Hodgson wrote: > On Wednesday, June 20, 2012 01:10:03 PM Sam Z J wrote: > > Hi all > > > > I'm curious how is wildcards at both ends implemented, e.g. LIKE '%str%' > > How

[GENERAL] efficiency of wildcards at both ends

2012-06-20 Thread Sam Z J
Hi all I'm curious how is wildcards at both ends implemented, e.g. LIKE '%str%' How efficient is it if that's the only search criteria against a large table? how much does indexing the column help and roughly how much more space is needed for the index? if the answers are too long, please point m