Re: Online 5.04: Miserable Performace

Posted in 1997

Mickey Mestel — Fri, 24 Jan 1997 14:43:10 -0800 — source: Informix-list mailing list archive (1991-1998)

mr. nasty, > : SELECT count(*) > : FROM contacts, companies > : WHERE companies.active = -1 > : AND contacts.active = -1 > : AND companies.company_id = contacts.company_id > : AND (description MATCHES "*cancer*lung*" OR > : interest MATCHES "*cancer*lung*") > > Informix is the slowest in a query of char fields. Plus having a * at the beginning > of matches statement does not help either. You should turn sqexplain on and see > what indexes (if any) this query is hitting. somone responded earlier that this would do much better as a union. check that posting out. mickm