1 Reply Latest reply: Jun 12, 2012 3:15 AM by Herald ten Dam RSS

    Will querying the text indexed tables while sync index degrades performance

    user13780543
      Hi All,

      We have noticed that the time taken to retrieve the results from the text indexed table is not consistent and it varies widely for the same input during different time.

      We doubt whether the time delay is due to the sync index on the table which is happeneing in parallel, while querying the text indexed table. Could anybody confirm and expalin on this please?

      Thanks.
        • 1. Re: Will querying the text indexed tables while sync index degrades performance
          Herald ten Dam
          Hi,

          yes, there is some overhead if you synchronize and also query on the same tables. But this overhead isn't that much, that it should be a concern.

          My question is, are you also optimizing the index? If not, then you should definitely do it, read http://docs.oracle.com/cd/E11882_01/text.112/e24435/aoptim.htm#i1006852 and the links given. A good start is to get a report about the index with CTX_REPORT.INDEX_STATS, this will give you insight on the status of the index. The next point if the index is not fragmented is to look at the queries and the memory use on the index.

          Herald ten Dam
          http://htendam.wordpress.com