OraFAQ Forum: Text & interMedia » Create Index for CLOB-datatype

Home » Server Options » Text & interMedia » Create Index for CLOB-datatype (Oracle Locator 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Create Index for CLOB-datatype [message #655598]

Mon, 05 September 2016 07:31

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)

Report message to a moderator

[Message index]

		Create Index for CLOB-datatype By: moehre on Mon, 05 September 2016 07:31
		Re: Create Index for CLOB-datatype By: John Watson on Mon, 05 September 2016 08:36
		Re: Create Index for CLOB-datatype By: Barbara Boehmer on Mon, 05 September 2016 16:05

Previous Topic:	Fulltext search
Next Topic:	Search over multiple Columns and Tables possible?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 09:27:02 CDT 2024