http://h2database.com/html/features.html#computed_columns
On Fri, 10 Apr 2020 at 11:49, Chen Huang 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:
>
> CREA
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: