This discussion is archived
1 Reply Latest reply: Nov 6, 2012 1:17 AM by Herald ten Dam RSS

Time for context Index Creation

sri333 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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