[
https://issues.apache.org/jira/browse/TRAFODION-2401?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anoop Sharma reassigned TRAFODION-2401:
---------------------------------------
Assignee: Anoop Sharma
> Creating Foreign Key constraint NOT ENFORCE still create system index
> ---------------------------------------------------------------------
>
> Key: TRAFODION-2401
> URL: https://issues.apache.org/jira/browse/TRAFODION-2401
> Project: Apache Trafodion
> Issue Type: Improvement
> Components: sql-cmp
> Affects Versions: 2.2-incubating
> Reporter: Eric Owhadi
> Assignee: Anoop Sharma
>
> if you create a table and declare a foreign key not enforced, to help
> optimizer make good decision in plan selection, but still you elected to "not
> enforce" the FK checking to improve ingestion performance, trafodion is still
> creating a system index, and therefore impact ingest performance. The index
> is never used, as the FK is not enforced, but we are still paying the cost of
> index maintenance
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
