Describe The Process Steps You Would Perform When
Defragmenting A Data Table. This Table Contains Mission Critical Data?
Ch KashifEnlightened
Power BI
Share
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this answer should be reported.
Describe The Process Steps You Would Perform When
Defragmenting A Data Table. This Table Contains Mission Critical Data?
Ch Kashif
There are several ways to do this:
1) We can move the table in the same or other tablespace and rebuild all the indexes
on the table. Alter table move this activity reclaims the defragmented space in the table analyze table table_name compute statistics to capture the updated statistics.
2) Reorg could be done by taking a dump of the table, truncate the table and import
the dump back into the table.