– hrms_person的CREATE_TIME增加索引
ALTER TABLE hrms_person ADD INDEX ‘IDX_HRMS_PERSON_CT’ (CREATE_TIME’) USING BTREE;
– 删除索引
ALTER TABLE hrms_person DROP INDEX ‘IDX_HRMS_PERSON_CT’;
– hrms_person的CREATE_TIME增加索引
ALTER TABLE hrms_person ADD INDEX ‘IDX_HRMS_PERSON_CT’ (CREATE_TIME’) USING BTREE;
– 删除索引
ALTER TABLE hrms_person DROP INDEX ‘IDX_HRMS_PERSON_CT’;