You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "ASF subversion and git services (Jira)" <ji...@apache.org> on 2023/03/24 16:39:00 UTC
[jira] [Commented] (ASTERIXDB-3148) Enable batch point lookup by default
[ https://issues.apache.org/jira/browse/ASTERIXDB-3148?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17704707#comment-17704707 ]
ASF subversion and git services commented on ASTERIXDB-3148:
------------------------------------------------------------
Commit bf6c3f86d124bcb335d3fa67f68137a0b0d1c0ad in asterixdb's branch refs/heads/master from Wail Alkowaileet
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=bf6c3f86d1 ]
[ASTERIXDB-3148][COMP] Enable batch point lookup by default
- user model changes: yes
- storage format changes: no
- interface changes: no
Details:
Currently single point lookups are performed by default.
This patch changes the defalut to be batch point lookups.
Change-Id: I897f3a84ede7165bac59cd7df40fc4fd7133a113
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17442
Integration-Tests: Jenkins <je...@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>
Reviewed-by: Wail Alkowaileet <wa...@gmail.com>
Reviewed-by: Murtadha Hubail <mh...@apache.org>
> Enable batch point lookup by default
> ------------------------------------
>
> Key: ASTERIXDB-3148
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3148
> Project: Apache AsterixDB
> Issue Type: Improvement
> Components: COMP - Compiler
> Affects Versions: 0.9.9
> Reporter: Wail Y. Alkowaileet
> Assignee: Wail Y. Alkowaileet
> Priority: Major
> Fix For: 0.9.9
>
>
> Currently, each point lookup traverses the B-Trees of the primary index top to bottom, which is inefficient. Since the keys produced by searching secondary indexes are sorted, the next record could reside in the same leaf page of the primary index. Hence no need to for re-traversing the B-Tree again.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)