Help Center/ Data Admin Service/ User Guide/ TaurusDB/ Table Management/ Maintaining a Table
Updated on 2026-07-28 GMT+08:00
View PDF
Share

Maintaining a Table

As workloads increase, frequent insert, update, and delete operations can cause table fragmentation, degrading database server performance. To address 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:

    • REPAIR TABLE Table_name: roughly repairs data and index files. No parameter is added.
    • REPAIR TABLE Table_name QUICK: repairs index files only. This method is faster than others.
    • REPAIR TABLE Table_name EXTENDED: re-creates indexes row by row to repair data and index files. This method is slower than others.

Check

  1. Log in to the DAS console.
  2. Click in the upper left corner and select a region and project.
  3. In the navigation pane on the left, choose Development Tool.

    You can also click Go to Development Tool on the overview page.

  4. Locate the DB instance that you want to log in to and click Log In in the Operation column.
  5. On the top menu bar, choose Database Management. On the displayed Objects tab, choose Tables on the left.
  6. In the right pane, locate the table you want to maintain and choose More > Maintain > Check in the Operation column.
  7. Select a check method as required.

    You can check a table with any of the following methods: Check, Quick, Fast, Changed, and Extended.
    Figure 1 Selecting a check method

  8. In the displayed dialog box, click Yes.

Repair

  1. Log in to the DAS console.
  2. Click in the upper left corner and select a region and project.
  3. In the navigation pane on the left, choose Development Tool.

    You can also click Go to Development Tool on the overview page.

  4. Locate the DB instance that you want to log in to and click Log In in the Operation column.
  5. On the top menu bar, choose Database Management.
  6. On the displayed Objects tab, choose Tables on the left.
  7. Locate the table you want to repair and choose More > Maintain > Repair in the Operation column.

    Figure 2 Repair

  8. Select a repair method as required.

    You select Check, Quick, or Extended.
    Figure 3 Selecting a repair method

  9. In the displayed dialog box, click Yes.
Parent topic: Table Management