Hi,

I have a long field that I need to browse through and I am thining
abou tthe possibilites of speeding up the query.

This is a large varchar UNICODE field, that alone is to big to fit
in index.

Is it possible to index the field partially? like this:

CREATE INDEX IDX_TABLE
ON TABLE (SUBSTRING(LONG_FIELD FROM 0 FOR 10))

The initial tests gave me negative on this. (by the way wouldn't
that be useful? it could help browsing the blobs also)

The other solution is to create another filed that is computed as
substring of the first and index this one.

Any other options?
What is the max index length for UNICODE?

CUIN Kaczy