Database Software

Hi,

I am on Oracle 11gR2 and I have a script to create Text indexes. I have total 12 text indexes (all part of single script) to be created on 8 tables. These tables have millions of records each.

Now, when I run this script, it takes about 8-10 hrs to completely execute it.

Syntax used (for one of my index):

   ctx_ddl.create_preference('MY_LEXER','BASIC_LEXER');

   ctx_ddl.set_attribute('MY_LEXER', 'printjoins', '-_');

   ctx_ddl.create_preference('MULTI_SEARCH_LOGS','MULTI_COLUMN_DATASTORE');

   ctx_ddl.set_attribute('MULTI_SEARCH_LOGS',

                         'columns',

                         'job_id, log_program');

   EXECUTE IMMEDIATE 'CREATE INDEX MY_LOG_HEAD_CTX1

                                ON MY_LOG_HEAD (SEARCH_LOGS_FLAG)

                         INDEXTYPE IS ctxsys.context

                        PARAMETERS (''DATASTORE MULTI_SEARCH_LOGS sync (on commit) LEXER my_lexer'') ';

Question: Is there a way/approach to quicken the process of index creation?

Thanks.