Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void CreateAnIndexOnthisTable(final String tableName, final String commaSeparatedColumnNames, final String indexName) {
- try {
- String sqlCreate = "CREATE INDEX " + indexName + " ON " + tableName + " (" + commaSeparatedColumnNames + ")";
- stmt = connRef.createStatement();
- stmt.execute(sqlCreate);
- } catch (SQLException ex) {System.out.println("Exception {} while creating index for {}"+ ex.getMessage()+ tableName);}
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement