| Issue with index tablespace. [message #175921] |
Tue, 06 June 2006 02:02  |
shahnazurs
Messages: 240
Registered: June 2005
Location: India
|
Senior Member |
|
|
Dear Friends,
In my database,index tablespace is keep on growing! but i have table with retention period let us say 30 day where i created index. could you please let me know what should i do?
|
|
|
|
|
|
| Re: Issue with index tablespace. [message #176094 is a reply to message #175965] |
Tue, 06 June 2006 22:26  |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
If you have an index with a DATE as the leading column, and you keep on deleting data older than 30 days, then the space used in the index for deleted rows will not be re-used. ie. You need to rebuild the index to recoup the space.
Ross Leishman
|
|
|
|
| Re: Issue with index tablespace. [message #176182 is a reply to message #176094] |
Wed, 07 June 2006 04:45 |
shahnazurs
Messages: 240
Registered: June 2005
Location: India
|
Senior Member |
|
|
If i do rebuilding index,could you please tell me how much time it takes for the table housing millions of records.
please tell me what will happen if any user accessing that table when the rebuilding starts?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
