How do you preserve the space in a LIKE statement (% WORD1%)?  Any assistance you can provide would be greatly appreciated.
 

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,

Hi All,
    Is there anyway to improve the performance(Reducing the CPU consumed is the main aim for now) of queries involving like in the where clause.
 
 
WHERE FIRST_NM LIKE :V_FIRST_NM||'%'
AND LAST_NM LIKE :V_LAST_NM||'%';