Create an index on a custom field

[jdorge]

I would like to create an index on a custom field but I can't find in mysql the table that sugar puts custom fields into. I've looked in the custom_fields table but it's empty. If it somewhere else?

Thanks.

[Angel]

The field definition is in fields_meta_data, but to add the index, you should follow the advice here: http://www.sugarcrm.com/forums/showthread.php?t=34350