OraFAQ Forum: Text & interMedia » CONTEXT INDEX and Tune LIKE clause (merged by bb and mc)

Home » Server Options » Text & interMedia » CONTEXT INDEX and Tune LIKE clause (merged by bb and mc)

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

CONTEXT INDEX and Tune LIKE clause (merged by bb and mc) [message #348982]

Thu, 18 September 2008 08:21

getritesh
Messages: 235
Registered: July 2006
Location: INDIA

Senior Member

Hello sir,

I created EMP table with column ENAME of type Varchar2(10) and added some records, next i created a Context index on ENAME
and executed a query

Select ENAME
From EMP
Where Contains(ENAME,'%'||'ER'||'%') > 0

I GOT CORRECT RESULT

But later i added few more records and ran the query but it didn't showed the extra rows in output which were also satisfying the query criteria

Later i came to know that Context index needs to be synchronized with CTX_DDL.SYNC_INDEX('index_name')

If so then whats the use of this index in OLTP applications where the index needs to be automatically updated.

Is there any method to automatically update Context index?

Thanks in advance

Report message to a moderator

[Message index]

		CONTEXT INDEX and Tune LIKE clause (merged by bb and mc) By: getritesh on Thu, 18 September 2008 08:21
		Re: CONTEXT INDEX By: Barbara Boehmer on Thu, 18 September 2008 10:02
		Tune LIKE clause By: getritesh on Thu, 18 September 2008 22:43
		Re: Tune LIKE clause By: Barbara Boehmer on Thu, 18 September 2008 23:24

Previous Topic:	package and oracle text search AND SOS,SOS,Search,Search,SOS (merged by bb)
Next Topic:	Problem with Fuzzy Query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 19:50:20 CDT 2024