This discussion is archived
4 Replies Latest reply: Dec 27, 2012 10:38 AM by 949210 RSS

difference between catsearch(ctxcat) and contains(context)

949210 Newbie
Currently Being Moderated
I am referring
http://docs.oracle.com/cd/B28359_01/text.111/b28303/ind.htm
http://www.oracle.com/technetwork/database/enterprise-edition/ctxcat-primer-090555.html
both give details about oracle text
the question that remains is when not to use catsearch
yes it is answered in the second document already but if you can provide a little more definitive answer to
when not to use catsearch or "what are the other reasons not to use catsearch" I am sure it will dis-spell many doubts of many
thank you very much
(I have not mentioned my db version here, please write about the latest-11g, most have 11g )

Edited by: 946207 on Dec 26, 2012 1:28 PM
  • 1. Re: difference between catsearch(ctxcat) and contains(context)
    Barbara Boehmer Oracle ACE
    Currently Being Moderated
    I am unable to access the second document, so I don't know what else you may have already read. There is a problem with ctxcat indexes and catsearch such that the optimizer may choose to try to use functional invocation at unpredictable times, but since catsearch does not support functional invocation it results in an error instead of returning results. Context indexes and contains do not have this problem. As of Oracle 11g, there appears to be little or nothing that ctxcat and catsearch can do that cannot be done with context and contains. Therefore, I always recommend not using catsearch and ctxcat.
  • 2. Re: difference between catsearch(ctxcat) and contains(context)
    949210 Newbie
    Currently Being Moderated
    [url http://lmgtfy.com/?q=the+ctxcat+index+type+what+is+it%3F%3F]try this one
    :
    :
    [url https://www.google.co.in/search?q=when+not+to+use+ctxcat&oq=when+not+to+use+ctxcat&sugexp=chrome,mod=13&sourceid=chrome&ie=UTF-8#hl=en&tbo=d&sclient=psy-ab&q=the+ctxcat+index+type+what+is+it%3F%3F&oq=the+ctxcat+index+type+what+is+it%3F%3F&gs_l=serp.3...7752.19481.0.19760.55.43.0.0.0.5.440.7021.0j31j6j2j1.40.0.les%3B..0.0...1c.1.50RYIaFEls8&pbx=1&bav=on.2,or.r_gc.r_pw.r_cp.r_qf.&bvm=bv.1355534169,d.bmk&fp=abe7578b7545eafb&bpcl=40096503&biw=1422&bih=727]and this one


    click the first page that it shows, one of them should work for you, no condescension intended
    it is written by Roger Ford

    [url http://lmgtfy.com/?q=the+ctxcat+index+type+what+is+it%3F%3F&l=1]try this also

    Edited by: 946207 on Dec 27, 2012 10:17 AM
  • 3. Re: difference between catsearch(ctxcat) and contains(context)
    Barbara Boehmer Oracle ACE
    Currently Being Moderated
    I am now able to access the original link, so apparently the problem was temporary. I previously got a strange error something about needing to be in contribution mode to access the page. These do not change what I previously posted. I still believe you should use context and contains. Also, you can post links from a regular Google search without using lmgtfy.
  • 4. Re: difference between catsearch(ctxcat) and contains(context)
    949210 Newbie
    Currently Being Moderated
    [url https://www.google.co.in/search?q=when+not+to+use+ctxcat&oq=when+not+to+use+ctxcat&sugexp=chrome,mod=13&sourceid=chrome&ie=UTF-8#hl=en&tbo=d&sclient=psy-ab&q=the+ctxcat+index+type+what+is+it%3F%3F&oq=the+ctxcat+index+type+what+is+it%3F%3F&gs_l=serp.3...7752.19481.0.19760.55.43.0.0.0.5.440.7021.0j31j6j2j1.40.0.les%3B..0.0...1c.1.50RYIaFEls8&pbx=1&bav=on.2,or.r_gc.r_pw.r_cp.r_qf.&bvm=bv.1355534169,d.bmk&fp=abe7578b7545eafb&bpcl=40096503&biw=1422&bih=727]and this one

    posted above is a quintessential example

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points