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 [EMAIL PROTECTED] 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 // ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
