[jira] [Created] (TRAFODION-1423) Indexes on trafodion should be created in aligned row format by default

["Selvaganesan Govindarajan (JIRA)" <ji...@apache.org>]

Selvaganesan Govindarajan created TRAFODION-1423:
----------------------------------------------------

             Summary: Indexes on trafodion should be created in aligned row format by default
                 Key: TRAFODION-1423
                 URL: https://issues.apache.org/jira/browse/TRAFODION-1423
             Project: Apache Trafodion
          Issue Type: Improvement
          Components: sql-cmp, sql-cmu
    Affects Versions: 2.0-incubating
            Reporter: Selvaganesan Govindarajan


Currently indexes are created with the same row format as the table. However, indexes can be created in aligned row format independent of the table because the columns in the index table doesn't have any other column other than salt, index columns, and primary key of the table. These column values constitute the rowid. Index rows are always deleted and inserted and are never updated. Hence, it goes well to create index in aligned row format. In addition, index in aligned row format has the following advantages:

- Reduced storage space for the index
- Reduced block cache and memstore space at runtime




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)