Revision 44678 trunk/org.gvsig.desktop/org.gvsig.desktop.compat.cdc/org.gvsig.fmap.dal/org.gvsig.fmap.dal.db/org.gvsig.fmap.dal.db.jdbc/src/main/java/org/gvsig/fmap/dal/store/jdbc2/spi/operations/UpdateTableStatisticsOperation.java

View differences:

UpdateTableStatisticsOperation.java
31 31 

  		




  32
  32
  
    
    @Override


  		




  33
  33
  
    
    public final Object perform(Connection conn) throws DataException {


  		




  34
  
  
    
        this.updateTableStatistics(conn, table);


  		




  
  34
  
    
        this.updateTableStatistics(conn);


  		




  35
  35
  
    
        return true;


  		




  36
  36
  
    
    }


  		




  37
  
  
    

  		




  38
  
  
    
    public void updateTableStatistics(


  		




  39
  
  
    
            Connection conn,


  		




  40
  
  
    
            TableReference table


  		




  41
  
  
    
        ) throws DataException {


  		




  42
  
  
    

  		




  
  37
  
    
    


  		




  
  38
  
    
    public List<String> getSQLs() {


  		




  43
  39
  
    
        JDBCSQLBuilderBase sqlbuilder = this.createSQLBuilder();


  		




  44
  40
  
    
        sqlbuilder.update_table_statistics().table()


  		




  45
  41
  
    
                .database(this.table.getDatabase())


  		




  ......




  47
  43
  
    
                .name(this.table.getTable());


  		




  48
  44
  
    
        List<String> sqls;


  		




  49
  45
  
    
        sqls = sqlbuilder.update_table_statistics().toStrings();


  		




  50
  
  
    

  		




  
  46
  
    
        return sqls;


  		




  
  47
  
    
    }


  		




  
  48
  
    
    


  		




  
  49
  
    
    public void updateTableStatistics(Connection conn) throws DataException {


  		




  
  50
  
    
      List<String> sqls = this.getSQLs();


  		




  51
  51
  
    
        Statement st = null;


  		




  52
  52
  
    
        try {


  		




  53
  53
  
    
            st = conn.createStatement();


  		












Also available in:  Unified diff