Menu

Index Storage - Tablespace

Help
David Webb
2011-07-23
2013-04-15
  • David Webb

    David Webb - 2011-07-23

    When I create the LuceneIndex, I am assuming it is stored in the user's default tablespace.  Is that correct?

    Can I specific which tablespace for the index to be stored in?

    Thank you.

     
  • Marcelo F. Ochoa

    Hi David:
       You can change any LOB storage parameter using the LDI LobStorageParameters parameter.
       See the Apendix and Examples section at the new LDI web site.
       Basically the lob columns which stores the Lucene files is created as:
    create table IDX_NAME$T (
    ….
        DATA          BLOB,
        DELETED       CHAR(1)
        ) LOB (DATA) STORE AS SECUREFILE (LobStorageParameters)
        So can change or you must change the LOB storage parameters with something more accurate to index content.
        I am working on the new release 3.2.x with many many performance enhancement.
        Stay tuned at the new project web site at SF.net
        Best regards, Marcelo.

     

Log in to post a comment.