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;