Home » RDBMS Server » Performance Tuning » Index Question
Index Question [message #118232] Tue, 03 May 2005 14:34 Go to next message
j_potucek
Messages: 6
Registered: April 2005
Junior Member
MIght be a dumb question... but here goes....

Oracle 9I on Windows platform.
If I create an index like below:

CREATE INDEX TABLE.E_DTDEALUNIT2_INX
ON TABLE.DT_DEAL_UNIT(VERSION_NUM,UNIT_NUM,LINE_NUM)
PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE SPACE_LI
STORAGE(BUFFER_POOL DEFAULT)
NOLOGGING
NOPARALLEL
NOCOMPRESS

Is it possible just to drop the index at amy time without losing data or causing other problems?
Re: Index Question [message #118234 is a reply to message #118232] Tue, 03 May 2005 15:04 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You store Data in the table.
You create index on table. This index occupies some storage.
If you drop the index, your Table data is NOT dropped.
But if you drop the table, all associated indexes are gone.

so, you can drop the index at any time you want.

>> or causing other problems
The queries ( if effectively written, tables/indexes analyzed and CBO ever makes use of this index) may run slower.

and in 9i, i would forget about all the storage clauses, have the index created in parallel and with logging ( If this index / table/database is worth of anything and is being under somekind of hotbackup scheme).
Re: Index Question [message #122923 is a reply to message #118232] Thu, 09 June 2005 04:15 Go to previous message
nabeelkhan
Messages: 73
Registered: May 2005
Location: Kuwait
Member

This helped me alot:

http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96595/toc.htm
Previous Topic: What is happening with this sql?
Next Topic: Explain Plan - number of rows returned.
Goto Forum:
  


Current Time: Wed Sep 23 14:06:38 CDT 2020