| Index creation [message #115266] |
Fri, 08 April 2005 11:30  |
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  |
 |
Mahesh Rajendran
Messages: 10707
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
