Indexes on table [message #6525] |
Wed, 23 April 2003 04:46 |
Bhas
Messages: 2 Registered: April 2003
|
Junior Member |
|
|
Hi,
Can someone provide me the query to create an index on a table called excswip345:
Name Null? Type
---------------- -------- ----
CWAR NOT NULL VARCHAR2(3)
ITEM NOT NULL VARCHAR2(16)
COPR NUMBER(10,2)
TDAT DATE
STOC NUMBER(10,2)
DEMD NUMBER(10,2)
EXCS NUMBER(10,2)
SHRT NUMBER(10,2)
Do I just say create index i_excswip345 on excswip345?
Or do I have to specify columns for it? I do not have any primary keys, etc specified for it since it is a summary table where I store temporary data for reporting purposes.
(But I am getting rollback errors so I have to create an index)
Thanks in advance
Bhaswar
|
|
|
Re: Indexes on table [message #6528 is a reply to message #6525] |
Wed, 23 April 2003 07:40 |
Anand
Messages: 161 Registered: August 1999
|
Senior Member |
|
|
CREATE INDEX index_name ON table_name(column_name)
TABLESPACE tablepace_name;
This is just an illustration..
|
|
|