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 2024/12/16 18:49:00 UTC

[jira] [Commented] (ASTERIXDB-3525) Utilize secondary indexes with LIKE operator

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

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

Commit e42600383e596246c0fb9b8946aa920e619b967f in asterixdb's branch refs/heads/master from Ali Alsuliman
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=e42600383e ]

[ASTERIXDB-3525][COMP] Capture index hints for LIKE operator

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

Ext-ref: MB-56789
Change-Id: I75613c0c3df8ede32619338254e6c71c604de2c0
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/19204
Integration-Tests: Jenkins <je...@fulliautomatix.ics.uci.edu>
Tested-by: Ali Alsuliman <al...@gmail.com>
Reviewed-by: Ali Alsuliman <al...@gmail.com>
Reviewed-by: Peeyush Gupta <pe...@couchbase.com>


> Utilize secondary indexes with LIKE operator
> --------------------------------------------
>
>                 Key: ASTERIXDB-3525
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-3525
>             Project: Apache AsterixDB
>          Issue Type: Improvement
>          Components: COMP - Compiler
>    Affects Versions: 0.9.10
>            Reporter: Murtadha Makki Al Hubail
>            Priority: Major
>              Labels: triaged
>             Fix For: 0.9.10
>
>
> We should utilize secondary indexes when LIKE operator is used at least for the prefix cases (e.g., WHERE some_field LIKE "prefix%")



--
This message was sent by Atlassian Jira
(v8.20.10#820010)