Performance of "upper(company_name) LIKE '%XXX%'" when used in a where
clause is terrible. Thinking the case sensitivity was to blame I created
(and indexed) another column that mirrors the company names column but in
uppercase text. The explain output shows no improvement for
"upr_company_name LIKE '%XXX%'" but does show improvement (obviously) when
the 1st wildcard is removed ("LIKE 'XXX%'").The performance degrades exponentially as other tables are joined even though they are joined on foreign keys and indexed columns. Any advise on how to improve performance? maxdb v7.5.0.19 on 64bit Linux
