Index key prefix behaviour in MyISAM
I have a VARCHAR(510) column in my table and I'm gonna need a unique index (UNIQUE KEY) on it, since MyISAM index key prefix length limit is 1000 bytes I have to use index prefix like col_name(250).
My question is if this will lead to a duplication problem for the unique key or not?
it seems a posibility since this index will use the first 250 chars in the column which can be not unique although the whole column value is unique.
Subject
Views
Written By
Posted
Index key prefix behaviour in MyISAM
109
August 22, 2024 03:51AM
53
August 22, 2024 09:11AM
68
August 22, 2024 09:27AM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.