Answers for "create index in oracle db"

SQL
2

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;
Posted by: Guest on May-31-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language