phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Soldatov (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-4064) Why the group by the index field will execute scan over table.
Date Thu, 10 Aug 2017 17:48:01 GMT

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

Sergey Soldatov commented on PHOENIX-4064:
------------------------------------------

[~highfei2011@126.com] I believe that you are talking about local index and the explain plan
looks like it uses it. Current implementation of local indexes uses the same physical table,
so explain plan uses the same physical table name. You may check it by dropping the index(es)
and check the explain plan again. I believe that you will see full scan over the table. 

>  Why the group by the index field will execute scan over table.
> ---------------------------------------------------------------
>
>                 Key: PHOENIX-4064
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-4064
>             Project: Phoenix
>          Issue Type: Improvement
>    Affects Versions: 4.11.0
>            Reporter: jifei_yang
>              Labels: features
>             Fix For: 4.11.0
>
>
> Why the group by the index field will execute scan over table.
> I created a Phoenix table, and then created the index, all the fields are marked as index.
However, when the group by index field is executed, the execution plan is viewed and the index
is not used. Please help solve the next, thank you.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message