Brian Johnson created PHOENIX-1439:
--------------------------------------
Summary: LIKE doesn't appear to use skip scanning
Key: PHOENIX-1439
URL: https://issues.apache.org/jira/browse/PHOENIX-1439
Project: Phoenix
Issue Type: Improvement
Reporter: Brian Johnson
We had a query using several like statements of the form LIKE 'prefix|%' and
LIKE 'prefix2|%' ... and the performance was on par with a full table scan.
When we replaced it with BETWEEN 'prefix|' and 'prefix|FFFFFFF...' the query
time was substantially faster. It seems that the LIKE query should work with
skip scan, but I don't think it's being used.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
