[
https://issues.apache.org/jira/browse/PHOENIX-1439?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14210091#comment-14210091
]
James Taylor commented on PHOENIX-1439:
---------------------------------------
[~kbuzsaki] - let me know if you have the bandwidth to investigate this one.
Please try against Phoenix 4.2 RC1 that's currently being voted on (or head of
4.2 or 4.0 branch is fine too).
> 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
> Assignee: Kyle Buzsaki
>
> 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)
