[ https://issues.apache.org/jira/browse/TRAFODION-1423?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14652408#comment-14652408 ]
Selvaganesan Govindarajan commented on TRAFODION-1423: ------------------------------------------------------ Anoop suggested index creation in aligned format shouldn't be turned on by default. It should be off by default. > 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)