>>Select * from mytable t where t.mymemo like '%find me%' > >You can create a computed index for this: >CREATE INDEX idxname ON mytable COMPUTED BY (lowercase(mymemo))
Such an index does not help for LIKE '%...', it can only be used if the first character is a real character (i.e. not % or _). Moreover, the index will not be used if you use a parameter rather than constant with LIKE. Set
