Home » Other » General » Index creation
Index creation [message #115266] Fri, 08 April 2005 11:30 Go to next message
pal_lac
Messages: 1
Registered: April 2005
Location: Chennai
Junior Member
Can i create a index on table which is being used heavily. If so, will it picks up the index which got created.
Re: Index creation [message #115307 is a reply to message #115266] Sat, 09 April 2005 00:38 Go to previous message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>table which is being used heavily
Heavily queried?
Heavily inserted?
Heavily Modified?

Indexes are good when queried.
Indexes are bad ( loosely said. actually there is 'some' overhead) when inserted.
>>If so, will it picks up the index which got created.
You must mean a query here.
and it depends.
depends on the statistics available and skewness of data.
CBO decides whether to use an index or not based on above.


Previous Topic: Tablespace size
Next Topic: abt weak entities
Goto Forum:
  


Current Time: Wed Sep 22 05:53:16 CDT 2021