[ https://issues.apache.org/jira/browse/PHOENIX-1439?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Thomas D'Silva updated PHOENIX-1439: ------------------------------------ Fix Version/s: (was: 4.15.0) > 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 > Priority: Major > Labels: verify > > 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 (v7.6.3#76005)