OraFAQ Forum: Text & interMedia » CTXCAT / CONTEXT index

Home » Server Options » Text & interMedia » CTXCAT / CONTEXT index

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

CTXCAT / CONTEXT index [message #292053]

Mon, 07 January 2008 10:33

navkrish
Messages: 189
Registered: May 2006
Location: NJ,USA

Senior Member

Which index is better to search on text field
1) CTXCAT index (or)
2) CONTEXT index

I have a table of
NUM_ROWS = 3224629
BLOCKS = 140712
SAMPLE_SIZE = 3224629
with column NAME_VALUE as VARCHAR2 (1117 Byte).

Which index would be worth creating on this column NAME_VALUE.

BANNER
---------
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL Release 9.2.0.8.0 - Production
CORE	9.2.0.8.0	Production
TNS for Linux: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production

Regards,
Naveen

Report message to a moderator

[Message index]

		CTXCAT / CONTEXT index By: navkrish on Mon, 07 January 2008 10:33
		Re: CTXCAT / CONTEXT index By: BlackSwan on Mon, 07 January 2008 10:36
		Re: CTXCAT / CONTEXT index By: navkrish on Mon, 07 January 2008 10:40
		Re: CTXCAT / CONTEXT index By: navkrish on Mon, 07 January 2008 13:29
		Re: CTXCAT / CONTEXT index By: Kevin Meade on Mon, 07 January 2008 13:54
		Re: CTXCAT / CONTEXT index By: navkrish on Mon, 07 January 2008 15:49

Previous Topic:	How to search the word in pdf/word document
Next Topic:	[CONTAINS] No result whereas there are

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 13:31:57 CDT 2024