for (final AstNode dimensionTableNode : tableNodes) {
if (possibleColumn.toUpperCase().startsWith(dimensionTableNode.getName().toUpperCase() + PERIOD)) {
final AstNode colRef = nodeFactory().node(possibleColumn, indexNode, TYPE_COLUMN_REFERENCE);
if (asc || desc) {
colRef.addMixin(OracleDdlLexicon.TYPE_INDEX_ORDERABLE);
if (asc) {
colRef.setProperty(OracleDdlLexicon.INDEX_ORDER, "ASC");
} else {
colRef.setProperty(OracleDdlLexicon.INDEX_ORDER, "DESC");