OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Index Question

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Index Question [message #118232]

Tue, 03 May 2005 14:34

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?

Report message to a moderator

Re: Index Question [message #118234 is a reply to message #118232]

Tue, 03 May 2005 15:04

Mahesh Rajendran
Messages: 10708
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).

Report message to a moderator

Re: Index Question [message #122923 is a reply to message #118232]

Thu, 09 June 2005 04:15

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

Report message to a moderator

Previous Topic:	What is happening with this sql?
Next Topic:	Explain Plan - number of rows returned.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 06:33:58 CST 2025