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

Gabriel Reid resolved PHOENIX-609.
----------------------------------

    Resolution: Fixed

Bulk resolve of closed issues imported from GitHub. This status was reached by 
first re-opening all closed imported issues and then resolving them in bulk.

> explain select indexed column and general column,only full scan over primary 
> table
> ----------------------------------------------------------------------------------
>
>                 Key: PHOENIX-609
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-609
>             Project: Phoenix
>          Issue Type: Task
>            Reporter: hnucsbjd
>
> explain select indexed columns  from primary table,full scan over index 
> table,but explain select indexed column and general column together from 
> primary table,only full scan over primary table,why not full scan over index 
> table?
> primary table test(v,v2),index table test_idx(v)
> explain select v2 from test;
> +------------+
> |    PLAN    |
> +------------+
> | CLIENT PARALLEL 1-WAY FULL SCAN OVER TEST 
> explain select v from test;
> +------------+
> |    PLAN    |
> +------------+
> | CLIENT PARALLEL 1-WAY FULL SCAN OVER TEST_IDX
> explain select v,v2 from test;
> +------------+
> |    PLAN    |
> +------------+
> | CLIENT PARALLEL 1-WAY FULL SCAN OVER TEST



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Reply via email to