You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Ali Alsuliman (JIRA)" <ji...@apache.org> on 2017/08/03 22:56:01 UTC
[jira] [Created] (ASTERIXDB-2015) Create secondary primary index
Ali Alsuliman created ASTERIXDB-2015:
----------------------------------------
Summary: 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
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
(v6.4.14#64029)