Answers for "create indexes in oracle"

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
0

create index in oracle commanf

CREATE INDEX new_index_name ON table_name (column_name)
Posted by: Guest on December-31-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language