CREATE INDEX <index_name>
ON <table_name> (<column_name_list>)
PCTFREE 0
PARALLEL (DEGREE <integer>)
TABLESPACE <tablespace_name>
 
-- for example: 
 
CREATE INDEX pidx_sales_region
ON sales_table(user_id, region)
PCTFREE 0
PARALLEL (DEGREE 4)
TABLESPACE sales_us;
 
 
-- The following syntax is used to rebuild the index, rebuild an 
-- index partition, resume a failed operation, perform batch DML, 
-- add stopwords to index, add sections and stop sections to 
-- index, or optimize the index:
 
ALTER INDEX [schema.]INDEX REBUILD [PARTITION partname] [ONLINE] [PARAMETERS 
(paramstring)][PARALLEL N];
 
-- NOTE: You cannot use PARALLEL with ONLINE.
 
/*
The syntax for paramstring is as follows:
 
paramstring = 
 
 
'REPLACE 
[datastore datastore_pref] 
[filter filter_pref] 
[lexer lexer_pref] 
[wordlist wordlist_pref] 
[storage storage_pref] 
[stoplist stoplist] 
[section group section_group]
[memory memsize]
[index set index_set]
 
|    resume [memory memsize]
|    optimize [token index_token | fast | full [maxtime (time | unlimited)]
|    sync [memory memsize]
|    add stopword word [language language]
|    add zone section section_name tag tag
|    add field section section_name tag tag [(VISIBLE | INVISIBLE)]
|    add attr section section_name tag tag@attr
|    add stop section tag'
 
*/