|
-
When u delete or update a record in a table the corresponding index data in the index will not delete or updated instead for an update, a new record will be inserted in the index and rebuild will remove all those records that do not match with the table records and also rebuild will not remove an fragmentation in the index segment.But you can de-fragment the index segment when u drop and recreate with appropriate storage parameters.
cheese
anandkl
anandkl
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|