[ https://issues.jboss.org/browse/TEIID-5856?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5856: --------------------------------------- That is an odd mixture of a ddl and xml vdb. It should instead be: {code} <vdb name="db" version="1"> <connection-type>BY_VERSION</connection-type> <model name="sf" type="PHYSICAL" visible="true"> <property name="importer.useFullSchemaName" value="false"/> <property name="importer.NormalizeNames" value="false"/> <property name="importer.modelAuditFields" value="true"/> <property name="importer.importStatstics" value="true"/> <source connection-jndi-name="salesforce" name="salesforce" translator-name="mysalesforce"/> </model> <translator name="mysalesforce" type="salesforce"> <property name="supportsOrderBy" value="true"/> </translator> </vdb> {code} You can double check the if the stats are set by looking at the cardinality column on SYS.tables. There's also using hints inline http://teiid.github.io/teiid-documents/master/content/reference/FROM_Clau... {code} SELECT originalLicense.Id,originalLicense.Status__c,originalLicense.ReplacementLicenseID__c,originalLicense.LicenseId__c,originalLicense.vlic_Contract_Number__c,replacementLicense.LicenseId__c as replacementLicenseId ,replacementLicense.Id as replacementLicenseObjectId FROM Product_License__c originalLicense LEFT OUTER JOIN /*+ MAKEDEP */ Product_License__c replacementLicense ON originalLicense.ReplacementLicenseID__c = replacementLicense.Id where originalLicense.vlic_Contract_Number__c = :contractNumber {code} -- This message was sent by Atlassian Jira (v7.13.8#713008)