On Friday, June 11, 2004, 7:00:39 AM, Csongor wrote: FC> Hi,
FC> I have a table that has a few short text fields [text(4000), text(1000)] FC> I would like to index. Do you think it is a good idea to index them FC> "simply", or is it better if I create auxilary fields which hold the MD5 FC> for the text fields and index those? Would that be faster? The MD5 will be shorter - and so more of it will fit in RAM - so it will be faster. Better still if you can store it as a BIG INT because binary comparisons can be done (fewer cycles per comparison). Hope this helps, _M -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]