You are here: Pega 7 Platform Database > Database administration and performance > Viewing and modifying schema information manually > Defragmenting tables

Defragmenting tables

You can defragment a database table from the Schema Tools landing page. This operation can take some time to complete. After initiating an operation, you can view progress and verify completion by refreshing the landing page and clicking the History tab for the table.

  1. Click Designer Studio > System > Database > Schema Tools.
  2. Select the table that you want to defragment.
  3. Click Defragment table in the right pane.
  4. Click Yes.