[ 
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:
------------------------------------------

[~highfei2...@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)

Reply via email to