James Taylor created PHOENIX-4566:
-------------------------------------
Summary: Add the minimum possible value to start range for not
null columns
Key: PHOENIX-4566
URL: https://issues.apache.org/jira/browse/PHOENIX-4566
Project: Phoenix
Issue Type: Improvement
Reporter: James Taylor
We can increase the start key by appending the minimum value of any not null
trailing primary key columns. For example:
{code}
CREATE TABLE T (
A CHAR(1) NOT NULL,
B CHAR(1) NOT NULL,
C CHAR(1) NOT NULL,
CONSTRAINT PK PRIMARY KEY (A,B,C));
SELECT * FROM T WHERE A = 'A';
{code}
In this case, the start range of the scan could be 'A\0\0' instead of 'A'
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
