[
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:
------------------------------------------
[[email protected]] 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)
