Thanks for the reply. The Column which got created as a result of optimization has been deleted in the data tables.
I think we can't remove the optimization on the property once it is optimzed. However once the populated column is removed from the data tables, the column shouldn't come back by just saving the property. What do you think ?