On Friday 11 June 2004 07:00 am, Fagyal, Csongor wrote: > Hi, > > I have a table that has a few short text fields > [text(4000), text(1000)] I would like to index. Do > you think it is a good idea to index them "simply", > or is it better if I create auxilary fields which > hold the MD5 for the text fields and index those? > Would that be faster? > > Thank you, > - Csongor
How are you going to be retrieving them? md5ing them means you could only retrieve on an exact match of the entire field (i.e. you couldn't use wildcards such as "where myfield like 'cson%' ") Regards, John --------------------------------------- John Hicks Gulfbridge, Inc. "Putting the Web to work for your business." http://gulfbridge.com 561-586-8116 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
