Lars Hofhansl created PHOENIX-6647:
--------------------------------------
Summary: A local index should not be chosen for a full scan if
that scan is not covered by the index.
Key: PHOENIX-6647
URL: https://issues.apache.org/jira/browse/PHOENIX-6647
Project: Phoenix
Issue Type: Bug
Affects Versions: 5.1.2
Reporter: Lars Hofhansl
> explain select * from lineitem;
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+-----+
|
PLAN
| EST_BYTES_READ | EST |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+-----+
| CLIENT 103-CHUNK 17711182 ROWS 1059064693 BYTES PARALLEL 2-WAY ROUND ROBIN
RANGE SCAN OVER LINEITEM [1]
| 1059064693 | 177 |
| SERVER MERGE [0.PARTKEY, 0.SUPPKEY, 0.QUANTITY, 0.EXTENDEDPRICE,
0.DISCOUNT, 0.TAX, 0.RETURNFLAG, 0.LINESTATUS, 0.COMMITDATE, 0.RECEIPTDATE,
0.SHIPINSTRUCT, 0.SHIPMODE, 0.COMMENT] | 1059064693 | 177 |
| SERVER FILTER BY FIRST KEY ONLY
| 1059064693 | 177 |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+-----+
3 rows selected (0.056 seconds)
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
