[teiid-issues] [JBoss JIRA] Resolved: (TEIID-1167) Add support for primary key handling in temp tables

[Steve Hawkins (JIRA)]

     [ https://jira.jboss.org/browse/TEIID-1167?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Hawkins resolved TEIID-1167.
----------------------------------

    Resolution: Done


Added support for a primary key.

It allows null values, composite keys, and creates a clustered index that supports optimizations for comparison, like, in and order by.

This change also affected temp tables without primary keys to get much better update performance.  Buffer files are also compacted appropriately as updates are made.

> Add support for primary key handling in temp tables
> ---------------------------------------------------
>
>                 Key: TEIID-1167
>                 URL: https://jira.jboss.org/browse/TEIID-1167
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>    Affects Versions: 7.1
>            Reporter: Steve Hawkins
>            Assignee: Steve Hawkins
>             Fix For: 7.1
>
>
> We should add support for primary keys in our temp tables.   With indexing, this support will also be used as the basis for our intermediate view level caching.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira