[ https://issues.apache.org/jira/browse/ASTERIXDB-2015?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ali Alsuliman reassigned ASTERIXDB-2015: ---------------------------------------- Assignee: Ali Alsuliman > Create secondary primary index > ------------------------------ > > Key: ASTERIXDB-2015 > URL: https://issues.apache.org/jira/browse/ASTERIXDB-2015 > Project: Apache AsterixDB > Issue Type: Improvement > Components: IDX - Indexes > Reporter: Ali Alsuliman > Assignee: Ali Alsuliman > Priority: Major > > This change is regarding introducing secondary primary index. The secondary > primary index is a secondary B-Tree that is built on the primary keys of the > dataset but only stores the {PK} instead of the regular case {SK,PK}. The > purpose of this secondary is to optimize queries like SELECT count(*). > Instead of scanning the primary index, the secondary primary index would be > used to answer such queries. -- This message was sent by Atlassian JIRA (v7.6.3#76005)