I have two tables in MySQL 8, table A with primary key and table B with a foreign key of the same type on column 1. table B has an index on column 1. If I want to change the index on table/column B1, is it safe to create a new index on the column
(B1), then delete the old index?
By "change index" I want to say, add another column and sort order to the index. Like:
create index b1_b2_IDX on b (b1 DESC, b2 ASC) ;