Re: Performance Problem with Full Text Indexing

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 29 May 2006 22:34:54 -0700
Message-ID: <1148967294.046969.323090@y43g2000cwc.googlegroups.com>

Have you looked at CTXCAT and CATSEARCH() specifications? They do not work the way you think they do. Your

catsearch(B.address,A.address,NULL)>0

predicate is complete nonsense. Please, read up Oracle Text Reference and Application Developer's Guide. You can find complete Oracle documentation set on OTN, free of charge and searchable. Hint: CONTEXT index and CONTAINS() operator are more suitable for the task.

--
    Vladimir M. Zakharychev
    N-Networks, makers of Dynamic PSP(tm)
    http://www.dynamicpsp.com

Received on Tue May 30 2006 - 00:34:54 CDT