Is it possible to add a restriction like
ALTER TABLE `t1` ADD UNIQUE(`col1`, `col2`);
without creating an index? The index will not be used for any queries, so it will be a waste of space.
It would not be a problem if inserts and updates are slower, because the table is not updated very often.
source
share