0 - 1 of 1 tags for position in
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,

By TK@TD, 23 May 2014 | Tagged: index like position in string match partial | 2 comments