1 Reply Latest reply: Nov 6, 2012 3:17 AM by Herald ten Dam RSS

    Time for context Index Creation

    sri333
      Hi,
      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

      Thanks,
      Sri
        • 1. Re: Time for context Index Creation
          Herald ten Dam
          Hi,

          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
          http://htendam.wordpress.com