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

Posted to notifications@asterixdb.apache.org by "Michael J. Carey (Jira)" <ji...@apache.org> on 2020/03/09 23:03:00 UTC

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

Michael J. Carey created ASTERIXDB-2707:
-------------------------------------------

             Summary: 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
             Fix For: 0.9.5


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.3.4#803005)