getContextManager());
//we would like to use references index & table scan instead of
//what optimizer says for the dependent table scan.
Properties targetProperties = new FormatableProperties();
targetProperties.put("index", "null");
((FromBaseTable) fromTable).setTableProperties(targetProperties);
fromList.addFromTable(fromTable);
SelectNode resultSet = (SelectNode) nodeFactory.getNode(