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

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

     [ https://issues.apache.org/jira/browse/TRAFODION-1423?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Selvaganesan Govindarajan reopened TRAFODION-1423:
--------------------------------------------------

When HBASE_SERIALIZATION is turned on by default (see [TRAFODION-1462]), the indexes never could be created in aligned format because the table had serialized columns.  So, this feature of enabling aligned row format for indexes alone didn't work as expected. The table needs to be created in aligned row format for the indexes to be in aligned format.

We need to remove the restriction of the inability to create indexes when the table has serialized columns for this feature to be more effective. The default for the CQD TRAF_INDEX_ALIGNED_ROW_FORMAT will be turned to 'ON' by default after some performance testing

> 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
>            Assignee: 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)