How to index a CLOB column?
In research, I was able to find an that a LOB column could be moved to another tablespace then indexed.
So I plan to use these statements (below), to create a text index on CLOB column STATEMENT_TEXT.
Questions: What storage should be used for the CLOB column?
What index type is needed to create a text index on the CLOB column?
ALTER TABLE ANY_STATEMENT MOVE
TABLESPACE INFOWH2 STORAGE(INITIAL 4096K)
LOB (STATEMENT_TEXT) STORE lobsegment
(TABLESPACE INFOWH2 STORAGE (INITIAL 4096K |