oracle create index
CREATE INDEX my_index_name ON my_table (colName) TABLESPACE my_tablespace; -- Default tablespace is USER CREATE INDEX my_index_name ON my_table (trunc(myDateCol)); -- With parallelism CREATE INDEX my_index_name ON my_table (colName) PARALLEL 8;