• VARCHAR(50) and DECIMAL(18) are not good candidates for indexing. If you cannot modify indexes, you may not have choice.

    In principle, data type of column chosen to be indexed should not be long in byte.