[jira] [Created] (TRAFODION-2401) Creating Foreign Key constraint NOT ENFORCE still create system index

["Eric Owhadi (JIRA)" <ji...@apache.org>]

Eric Owhadi created TRAFODION-2401:
--------------------------------------

             Summary: 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


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)