1 Reply Latest reply on Nov 6, 2012 9:17 AM by Herald ten Dam

    Time for context Index Creation

      I am creating an context index in table having 10 million rows. But it is still running from 10 hours. Waht may be the expected time for completion
      of creating this index.

      Immediate replies are more helpful

        • 1. Re: Time for context Index Creation
          Herald ten Dam

          the answer is "it depends".

          - what are you indexing? 10M rows with PDF documents or just simple plain text?
          - what is your hardware?
          - how is your index made-up? Is it just a plain index or do you use all kind of features (substring etc)?
          - Which version of Oracle are you using?

          In the oracle documentation you can find information about this issue: http://docs.oracle.com/cd/E11882_01/text.112/e24435/aoptim.htm#i1006756

          Herald ten Dam