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; } }