[jira] [Commented] (ASTERIXDB-2892) Long Query Time w/ Array Index Range Query

["ASF subversion and git services (Jira)" <ji...@apache.org>]

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

ASF subversion and git services commented on ASTERIXDB-2892:
------------------------------------------------------------

Commit e75c8ef10fb419e5424f2ff4e3f81fcac0c6815b in asterixdb's branch refs/heads/master from Glenn
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=e75c8ef ]

[ASTERIXDB-2892][IDX] Fixing bug w/ range queries for array indexes.

- user mode changes: no
- storage format changes: no
- interface changes: no

Given some range queries where the range is on the lower end of the
index sort order and extremely selective, queries were still taking as
long as a full dataset scan.
Cause was discovered: the sidx-search was always assuming that the
upper-bound was not defined, and the primary-index validation would
remove an excessive amount of false positives.

Change-Id: I0c2c821e7005d821056324d5736bea904dd9ad7a
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/11205
Integration-Tests: Jenkins <je...@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>
Reviewed-by: Dmitry Lychagin <dm...@couchbase.com>


> Long Query Time w/ Array Index Range Query
> ------------------------------------------
>
>                 Key: ASTERIXDB-2892
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2892
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: IDX - Indexes
>            Reporter: Glenn Galvizo
>            Assignee: Glenn Galvizo
>            Priority: Major
>
> Given some range queries where the range is on the lower end of the index sort order and extremely selective, queries are still taking as long as a full dataset scan. 
>  
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)