Unique & Prefix Indexes
Learn Unique & Prefix Indexes (Indexes, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction A UNIQUE index is a B-Tree that also rejects duplicate keys (NULLs are allowed and may repeat). A prefix index indexes only the first N characters/bytes of a string column, e.g. url(20) , to save space.