MySQL Forums
Forum List  »  MyISAM

Index key prefix behaviour in MyISAM
Posted by: Hassan Bahrami
Date: August 22, 2024 03:51AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Index key prefix behaviour in MyISAM
109
August 22, 2024 03:51AM


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.