Tags for match
Parentheses matching only works partially
Hello, I was working with the following Aster Express query in Studio: SELECT DISTINCT path, count(*) cnt FROM nPath ( ON bank_web_clicks PARTITION BY customer_id, session_id ORDER BY datestamp MODE(NONOVERLAPPING) PATTERN ('PAGE+.BME') SYMBOLS ( TRUE AS PAGE,
match parenthesis parentheses
Avoid all rows scan on partial varchar access
Hi to the performance experts among you.   We have a pretty large key table, with at least one VARCHAR(30) column storing the real world source key, here SOURCE_KEY_COLUMN1, and one bigint column storing the surrogate key (PI), here EVENT_ID.   CREATE MULTISET TABLE KEY_EVENT [...]      (       EVENT_ID BIGINT,
index like position in string match partial