Create indexes just up to a specified length of the data values, e.g.: CREATE INDEX name ON person (name(10))
Log in to post a comment.