1 Reply Latest reply: Sep 23, 2012 7:05 AM by phaeus RSS

    Oracle Text Index

    Ayham
      Hi all,

      I have one queston about Oracle Text Index :

      Is the Oracle text index used after enter data into CLOB column or before? or anytime.


      CREATE INDEX Ora_TXT_Index_ON_Test ON te1(name) INDEXTYPE IS CTXSYS.CONTEXT;

      EXEC DBMS_STATS.GATHER_TABLE_STATS(USER, 'TE1', cascade=>TRUE);

      regards
        • 1. Re: Oracle Text Index
          phaeus
          Hello,
          a text index is not used in normal manner. You must use a contains clause in your SQL Statement which is searching your Text Index for the searchword. A Oracle Text Index will be refreshd in manual way or if you specify on commit at your index.

          Maybe this Links help you
          http://oracle-text-de.blogspot.co.at/2008/06/scoring-mit-oracle-text.html
          http://docs.oracle.com/cd/B19306_01/text.102/b14218/cqoper.htm

          regards
          Peter