public static void ReIndexTable(string tableName)
{
try
{
OracleHandler sqlH = new OracleHandler();
sqlH.ExecuteSQL("ALTER INDEX ALL ON " + tableName + " REBUILD WITH (FILLFACTOR=90,ONLINE=ON)");
}
catch (Exception e)
{
throw e;
}
}
public static void ReOrganizeTable(string tableName)
{
try
{
OracleHandler sqlH = new OracleHandler();
sqlH.ExecuteSQL("ALTER INDEX ALL ON " + tableName + " REORGANIZE");
}
catch (Exception e)
{
throw e;
}
}
