This discussion is archived
1 Reply Latest reply: Oct 26, 2012 8:31 AM by Roger Ford RSS

space needed by context index

sri333 Newbie
Currently Being Moderated
Can some one tell me how much space is required for context index creation.Since it depends on table size please tell me in comparison with space occupied by table.
Example: if table takes 100MB then context index needs some 200MB etc..

Quick Replies are Helpful

  • 1. Re: space needed by context index
    Roger Ford Expert
    Currently Being Moderated
    The answer is, of course, "it depends"!

    However, if you are indexing plain text, and using the default options (in particular, not using the SUBSTRING_INDEX option) then your index size will be typically 35-45% of the original text size. So 100MB of text will require 35-45MB of index space.

    If you're indexing word or PDF documents with embedded graphics, the overhead will be much lower.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points