Hi all,
I've got an interesting issue going on with Teradata. Suppose I have a table tbl with columns col1, col2, col3 with col1 being the primary key.
I can run 

Select * from tbl where col2 like '%abc%'

However, if I attempt to run the following:

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,