OraFAQ Forum: Text & interMedia » CONTEXT index and Tune with context (2 cross-posts merged by bb)

Home » Server Options » Text & interMedia » CONTEXT index and Tune with context (2 cross-posts merged by bb)

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

CONTEXT index and Tune with context (2 cross-posts merged by bb) [message #350679]

Thu, 25 September 2008 21:46

getritesh
Messages: 235
Registered: July 2006
Location: INDIA

Senior Member

Hello Sir,

I'm using CONTEXT index for one table column, now in my query i'm using statement shown below

Where Contains(pdue_policy_no,:prm_policy_no) > 0

but in fact i'have to use

Where pdue_policy_no =
nvl(:prm_policy_no,nvl(pdue_policy_no,'ZZ'))

since if :prm_policy_no is NULL it shold get value in pdue_policy_no but if i use Contains i cannot use nvl.But Contains is giving performance improvement

Thanks in advance for your guidance

Report message to a moderator

[Message index]

		CONTEXT index and Tune with context (2 cross-posts merged by bb) By: getritesh on Thu, 25 September 2008 21:46
		CONTEXT index and Tune with context (2 cross-posts merged by bb) By: Barbara Boehmer on Mon, 29 September 2008 15:58
		Re: CONTEXT index and Tune with context (2 cross-posts merged by bb) By: Barbara Boehmer on Mon, 29 September 2008 16:04
		Tune with context index By: getritesh on Tue, 30 September 2008 01:32
		Re: Tune with context index By: Barbara Boehmer on Tue, 30 September 2008 15:43
		Re: Tune with context index By: getritesh on Wed, 01 October 2008 12:12
		Re: Tune with context index By: Barbara Boehmer on Wed, 01 October 2008 18:20
		Re: Tune with context index By: getritesh on Thu, 02 October 2008 00:01
		Re: Tune with context index By: Barbara Boehmer on Thu, 02 October 2008 00:36
		Re: Tune with context index By: getritesh on Thu, 02 October 2008 04:41
		Re: Tune with context index By: Barbara Boehmer on Thu, 02 October 2008 09:17

Previous Topic:	Near operator with Ctxcat index (split from CTXCAT / CONTEXT index by bb)
Next Topic:	select query optimization

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 07:50:44 CDT 2024