You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@asterixdb.apache.org by "Till Westmann (Jira)" <ji...@apache.org> on 2022/02/17 01:53:00 UTC

[jira] [Updated] (ASTERIXDB-2707) B+ tree indexes not used for LIKE queries!

     [ https://issues.apache.org/jira/browse/ASTERIXDB-2707?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Till Westmann updated ASTERIXDB-2707:
-------------------------------------
    Fix Version/s: 0.9.8
                       (was: 0.9.7)

> B+ tree indexes not used for LIKE queries!
> ------------------------------------------
>
>                 Key: ASTERIXDB-2707
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2707
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: *DB - AsterixDB, COMP - Compiler
>    Affects Versions: 0.9.4.1
>            Reporter: Michael J. Carey
>            Assignee: Dmitry Lychagin
>            Priority: Critical
>             Fix For: 0.9.8
>
>
> Try any LIKE prefix query, e.g., name LIKE 'Carey' or name LIKE 'Carey%', that should use an index on customer.name and you'll see - index not used!



--
This message was sent by Atlassian Jira
(v8.20.1#820001)