Jonathan Vanasco wrote:
> hoping someone may be able to offer advice:.
>
> SELECT
> *
> FROM
> table_a
> WHERE
> id != 10001
> AND
> (
> ( field_1 ilike '123' )
> OR
> ( field_2 ilike 'abc' )
> )
You seem to use that ilike expression merely as a case-insensitive
equals. May as well use that in combination with indices on
lower(field_[12]). It's probably faster than like or a regex match.
--
Alban Hertroys
alban@magproductions.nl
magproductions b.v.
T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
7500 AK Enschede
// Integrate Your World //
