Here is the syntax to create an index on a table in oracle:
CREATE INDEX INDEX_NAME ON TABLE_NAME(COLUMN_NAME);
If you want to specify tablespace you can do it as follows:
CREATE INDEX INDEX_NAME ON TABLE_NAME(COLUMN_NAME)
TABLESPACE TABLE_SPACE;
Isn't that easy?
CREATE INDEX INDEX_NAME ON TABLE_NAME(COLUMN_NAME);
If you want to specify tablespace you can do it as follows:
CREATE INDEX INDEX_NAME ON TABLE_NAME(COLUMN_NAME)
TABLESPACE TABLE_SPACE;
Isn't that easy?
No comments:
Post a Comment