Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!colt.net!news-lond.gip.net!news-raspail.gip.net!news.gsl.net!gip.net!grolier!v.t-online.fr!t-online.fr!news.glorb.com!postnews.google.com!i40g2000cwc.googlegroups.com!not-for-mail From: "jsfromynr" Newsgroups: comp.databases.oracle.server Subject: Re: Performance Problem with Full Text Indexing Date: 30 May 2006 00:09:00 -0700 Organization: http://groups.google.com Lines: 42 Message-ID: <1148972939.948894.129500@i40g2000cwc.googlegroups.com> References: <1148963519.789667.319780@u72g2000cwu.googlegroups.com> <1148967294.046969.323090@y43g2000cwc.googlegroups.com> NNTP-Posting-Host: 210.211.246.201 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1148972945 18952 127.0.0.1 (30 May 2006 07:09:05 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Tue, 30 May 2006 07:09:05 +0000 (UTC) In-Reply-To: <1148967294.046969.323090@y43g2000cwc.googlegroups.com> User-Agent: G2/0.2 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; nxforms/1.00; FunWebProducts; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe) X-HTTP-Via: 1.0 pun.clover.prv:3180 (Squid/2.4.STABLE6) Complaints-To: groups-abuse@google.com Injection-Info: i40g2000cwc.googlegroups.com; posting-host=210.211.246.201; posting-account=Chq5lA0AAABHMbWnWx9ZzOoZeqjmADHE Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:268232 Thanks Validimar, I specified NULL as there was no mixed query . The search was only on the specified column . I had choosen CTXCAT as it is transactional so indexes will be up to date, which would not be the case with CONTEXT. Thanks for your Hint and advice. As I was trying to drop the index I was unable to do so. *** drop index abc force; *** Oracle had dropped DR* indexes but not the abc index. I might be asking for more but could you explain "how parse searching happens in case fulltext index is used" ?? In case of keywords , I assume this is what Oracle does. rowid column1 1 This is a big box. 2 This is not a big box. Full text Index would hold (my assumption can be totally wrong) This 1 This 2 is 1 is 2 a 1 a 2 big 1 big 2 not 2 box 1 box 2 Now if predicate is " catsearch(column1,'"is box"',NULL)>0 " --- Again I used NULL as it is no mixed query and I wish to have transcational index management . Does oracle also stores keyword position in the index as well?? With Warm Regards Jatinder SIngh