public static void buildValidationIndexes( Properties props) {
		String url = props.getProperty(VALIDATION_DBURL_PROPERTY,
				VALIDATION_DBURL_PROPERTY_DEFAULT);
		String user = props.getProperty(VALIDATION_DBUSER_PROPERTY, VALIDATION_DBUSER_PROPERTY_DEFAULT);
		String passwd = props.getProperty(VALIDATION_DBPWD_PROPERTY, VALIDATION_DBPWD_PROPERTY_DEFAULT);
		String driver = props.getProperty(VALIDATION_DBDRIVER_PROPERTY,
				VALIDATION_DBDRIVER_PROPERTY_DEFAULT);

		Connection conn = null;
		Statement stmt = null;
		int machineid =Integer.parseInt(props.getProperty(Client.MACHINE_ID_PROPERTY, Client.MACHINE_ID_PROPERTY_DEFAULT));

		try {
			Class.forName(driver);
			conn = DriverManager.getConnection(url, user, passwd);
		} catch (Exception e) {
			e.printStackTrace(System.out);
		}

		try {
			int count = 1;
			if(props.getProperty(DB_TENANT_PROPERTY,DB_TENANT_PROPERTY_DEFAULT).equalsIgnoreCase("single"))
				count = 1;
			else 
				count = Integer.parseInt(props.getProperty(Client.THREAD_CNT_PROPERTY, Client.THREAD_CNT_PROPERTY_DEFAULT));

			stmt = conn.createStatement();
			long startIdx = System.currentTimeMillis();
			for(int i=1; i<=count; i++){
				dropIndex(stmt, "TUPDATE"+machineid+"c"+i+"_IDX$$_start");
				dropIndex(stmt, "TUPDATE"+machineid+"c"+i+"_IDX$$_end");
				dropIndex(stmt, "TUPDATE"+machineid+"c"+i+"_IDX$$_resource");
				dropIndex(stmt, "TUPDATE"+machineid+"c"+i+"_IDX$$_optype");

				stmt.executeUpdate("CREATE INDEX TUPDATE"+machineid+"c"+i+"_IDX$$_start ON TUPDATE"+machineid+"c"+i+" (STARTTIME)"
						+ "COMPUTE STATISTICS NOLOGGING");
				stmt.executeUpdate("CREATE INDEX TUPDATE"+machineid+"c"+i+"_IDX$$_end ON TUPDATE"+machineid+"c"+i+" (ENDTIME)"
						+ "COMPUTE STATISTICS NOLOGGING");
				stmt.executeUpdate("CREATE INDEX TUPDATE"+machineid+"c"+i+"_IDX$$_resource ON TUPDATE"+machineid+"c"+i+" (RID)"
						+ "COMPUTE STATISTICS NOLOGGING");
				stmt.executeUpdate("CREATE INDEX TUPDATE"+machineid+"c"+i+"_IDX$$_optype ON TUPDATE"+machineid+"c"+i+" (OPTYPE)"
						+ "COMPUTE STATISTICS NOLOGGING");

				stmt.executeUpdate("analyze table tupdate"+machineid+"c"+i+" compute statistics");
				long endIdx = System.currentTimeMillis();
				System.out.println("\t Time to build validation index for" +machineid+" structures(ms):"
						+ (endIdx - startIdx));

			}


		} catch (Exception e) {
			e.printStackTrace(System.out);
		} finally {
			try {
				if (stmt != null)
					stmt.close();
				if (conn != null)
					conn.close();
			} catch (SQLException e) {
				e.printStackTrace(System.out);
			}
		}

	}