Home » Server Options » Text & interMedia » Create Index for CLOB-datatype (Oracle Locator 11g)
Create Index for CLOB-datatype [message #655598] Mon, 05 September 2016 07:31 Go to previous message
moehre
Messages: 43
Registered: June 2016
Member
Hi,

I construct a json (geometry data) as a CLOB type inside my database.
Now I will create an index for this column.

I found this in the internet:

CREATE INDEX myclob_idx
ON surface_geometry (json)
INDEXTYPE IS ctxsys.context;

is this the right way?
I will reduce the time of accessing the CLOB data.

The access is realized through a Webserver (CLOB.read() method)
 
Read Message
Read Message
Read Message
Previous Topic: Fulltext search
Next Topic: Search over multiple Columns and Tables possible?
Goto Forum:
  


Current Time: Sat Mar 28 18:46:42 CDT 2020