INDEX ON VAL (CharField) ...>The exception to your statement is if you have to sort or display the column in numeric order. If the column is character then you have to deal with padding the left of the column with spaces or zeros to make it order correctly. I would rather use a number column and convert it to a character for display if an order is involved.