de.akquinet.jbosscc.guttenbase.tools.mssql.MSSqlReorgTablesTool Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of GuttenBase Show documentation

Copying done right...

The newest version!

package de.akquinet.jbosscc.guttenbase.tools.mssql;

import de.akquinet.jbosscc.guttenbase.repository.ConnectorRepository;
import de.akquinet.jbosscc.guttenbase.tools.AbstractTablesOperationTool;

import java.sql.SQLException;

/**
 * Will execute OPTIMIZE TABLE table;
 * 
 * © 2012-2034 akquinet tech@spree
 * 
 *
 * @author M. Dahm
 */
public class MSSqlReorgTablesTool extends AbstractTablesOperationTool {
  public MSSqlReorgTablesTool(final ConnectorRepository connectorRepository) {
    super(connectorRepository, "ALTER INDEX ALL ON " + TABLE_PLACEHOLDER +
        " REBUILD WITH (FILLFACTOR = 80, SORT_IN_TEMPDB = ON, STATISTICS_NORECOMPUTE = ON");
  }

  public void executeOnAllTables(final String target) throws SQLException {
    executeOnAllTables(target, false, false);
  }
}