To allow indexing on CHAR and VARCHAR columns wider than 255 bytes, include the PARTIAL keyword in the CREATE INDEX statement. If the column(s) that make up the partial index, including overhead, contain less than 255 bytes, PARTIAL is ignored.