trafodion-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rohit Jain <rohit.j...@esgyn.com>
Subject RE: [jira] [Commented] (TRAFODION-1423) Indexes on trafodion should be created in aligned row format by default
Date Mon, 03 Aug 2015 20:08:50 GMT
Curious, what were those suggestion :-)  Don't see JIRA comments on them.

-----Original Message-----
From: Selvaganesan Govindarajan (JIRA) [mailto:jira@apache.org]
Sent: Monday, August 3, 2015 2:48 PM
To: issues@trafodion.incubator.apache.org
Subject: [jira] [Commented] (TRAFODION-1423) Indexes on trafodion should be
created in aligned row format by default


    [
https://issues.apache.org/jira/browse/TRAFODION-1423?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14652362#comment-14652362
]

Selvaganesan Govindarajan commented on TRAFODION-1423:
------------------------------------------------------

Anoop suggested some more changes. I will push another version incorporating
his suggestions.

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

Mime
View raw message