Maintaining a Table
While working with a database, you do a lot of changes to tables such as inserting, updating and deleting data. This occupies disk space and deteriorates database performance. To handle this, periodic maintenance is required.
Functions
- Check
Allows you to check whether there are errors in database tables using the CHECK TABLE statement. You can check a table with any of the following methods: Check, Quick, Fast, Changed, and Extended.
- Check: scans rows to verify that deleted links are valid. Alternatively, calculate a key checksum for the rows and verifies the validity using the obtained checksum.
- Fast: neither scans rows nor checks for incorrect links.
- Quick: checks only tables that have not been closed properly.
- Changed: checks only the tables that have been changed since the last check and the tables that have not been closed properly.
- Extended: searches for keywords in each row.
The CHECK TABLE statement adds a read-only lock to the table.
- Repair
Allows you to use the REPAIR TABLE statement to repair possibly corrupted or incorrect tables. You can repair tables using any of the following three methods: Check, Quick, and Extended.
- Check: a simple repair, which repairs data and index files.
- Quick: the quickest repair, which repairs only index files, but not data files.
- Extended: the slowest repair, which creates indexes row by row to repair data and index files.
Check
- Click
in the upper left corner and select a region and project.
- Click
in the upper left corner, and under Databases, click Data Admin Service.
- In the navigation pane on the left, choose Development Tool.
- Locate the DB instance that you want to log in to and click Log In in the Operation column.
- On the top menu bar, choose Database Management. On the displayed Objects tab, choose Tables on the left.
- In the right pane, locate the table you want to maintain and choose More > Maintain > Check in the Operation column.
- Select a check method as required.
You can check a table with any of the following methods: Check, Quick, Fast, Changed, and Extended.
- In the displayed dialog box, click Yes.
Repair
- Click
in the upper left corner and select a region and project.
- Click
in the upper left corner, and under Databases, click Data Admin Service.
- In the navigation pane on the left, choose Development Tool.
- Locate the DB instance that you want to log in to and click Log In in the Operation column.
- On the top menu bar, choose Database Management.
- On the displayed Objects tab, choose Tables on the left.
- Locate the table you want to repair and choose More > Maintain > Repair in the Operation column.
- Select a repair method as required.
You can repair tables using any of the following three methods: Check, Quick, and Extended.
- In the displayed dialog box, click Yes.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.