Re: [PERFORM] Slow query with 'or' clause

2007-02-15 Thread philippe
Selon Richard Huxton : > philippe wrote: > > explain analyse > > select count(*) from client_contact > > left join client_company using(cli_id) > > where (cli_mail = '[EMAIL PROTECTED]') OR > > (lower(cli_nom) = 'xx' and zipcode = '10001'); > > > > QUERY PLAN > > >

Re: [PERFORM] Slow query with 'or' clause

2007-02-15 Thread Richard Huxton
philippe wrote: explain analyse select count(*) from client_contact left join client_company using(cli_id) where (cli_mail = '[EMAIL PROTECTED]') OR (lower(cli_nom) = 'xx' and zipcode = '10001'); QUERY PLAN -