4 Replies Latest reply: Dec 27, 2012 12:38 PM by 949210 RSS

    difference between catsearch(ctxcat) and contains(context)

    949210
      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
          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
            [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
              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
                [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