You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@empire-db.apache.org by do...@apache.org on 2012/07/27 10:04:26 UTC
svn commit: r1366304 -
/empire-db/trunk/empire-db/src/main/java/org/apache/empire/db/oracle/DBCommandOracle.java
Author: doebele
Date: Fri Jul 27 08:04:25 2012
New Revision: 1366304
URL: http://svn.apache.org/viewvc?rev=1366304&view=rev
Log:
EMPIREDB-141
allow multiple Index hints for Oracle Commands
Modified:
empire-db/trunk/empire-db/src/main/java/org/apache/empire/db/oracle/DBCommandOracle.java
Modified: empire-db/trunk/empire-db/src/main/java/org/apache/empire/db/oracle/DBCommandOracle.java
URL: http://svn.apache.org/viewvc/empire-db/trunk/empire-db/src/main/java/org/apache/empire/db/oracle/DBCommandOracle.java?rev=1366304&r1=1366303&r2=1366304&view=diff
==============================================================================
--- empire-db/trunk/empire-db/src/main/java/org/apache/empire/db/oracle/DBCommandOracle.java (original)
+++ empire-db/trunk/empire-db/src/main/java/org/apache/empire/db/oracle/DBCommandOracle.java Fri Jul 27 08:04:25 2012
@@ -81,7 +81,11 @@ public class DBCommandOracle extends DBC
// Set Index Hint
String tableAlias = index.getTable().getAlias();
String indexName = index.getName();
- this.optimizerHint = "INDEX ("+tableAlias+" "+indexName+")";
+ String indexHint = "INDEX ("+tableAlias+" "+indexName+")";
+ if (StringUtils.isNotEmpty(this.optimizerHint) && this.optimizerHint.indexOf(indexHint)<0)
+ this.optimizerHint = this.optimizerHint + " " + indexHint;
+ else
+ this.optimizerHint = indexHint;
}
/**