http://h2database.com/html/features.html#computed_columns
On Fri, 10 Apr 2020 at 11:49, Chen Huang <auntyel...@gmail.com> 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 h2-database+unsubscr...@googlegroups.com. > 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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/CAFYHVnWp68Xdt5R-gnzYzjp9SO1JHsdk6POAqrpCXmSt5mHG2g%40mail.gmail.com.
