I have a table with a TEXT/CLOB like column that need to be indexed:
CREATE TABLE test (id INT PRIMARY KEY, val VARCHAR(512))
but this index takes too much spaces:
CREATE INDEX test_val ON test(val)
Can I create an index with only a prefix of this column? like MySQL's
prefix index:
CREATE INDEX test_val ON test(val(20))
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/b97b567d-426d-4363-8526-fa89c7b26564%40googlegroups.com.
