http://h2database.com/html/features.html#computed_columns
On Fri, 10 Apr 2020 at 11:49, Chen Huang <[email protected]> wrote: > 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 > <https://groups.google.com/d/msgid/h2-database/b97b567d-426d-4363-8526-fa89c7b26564%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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/CAFYHVnWp68Xdt5R-gnzYzjp9SO1JHsdk6POAqrpCXmSt5mHG2g%40mail.gmail.com.
