Good question. And if you want to lengthen the column you can do it directly without dropping the index.