I have an existing table that have a column date but varchar datatype and also a date datetime datatype
columns: trx_id, activity, name, date(datetime)
columns: trx_id, activity, name, date(varchar)
is it ok to index date as varchar on trx2 and get the same expectation as trx1? OR
The best thing to do is to change the datatype to datetime also
Any comment or suggestion would be a great help TIA!