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

    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:

    Herald ten Dam