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@xxxxxxxxxxxxxxxxx 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 //
