[
https://issues.apache.org/jira/browse/PHOENIX-1439?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14208617#comment-14208617
]
Brian Johnson commented on PHOENIX-1439:
----------------------------------------
I had AND in the original description, but it should have been OR
> 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)
